Capture user selection of font

If I put a font combo box on a Ribbonbar is there a way for me to capture the 
user's font choice? I need to capture that choice and use it in a macro.
0
Utf
3/1/2010 8:34:01 PM
word.vba.general 1023 articles. 1 followers. Follow

2 Replies
1141 Views

Similar Articles

[PageSpeed] 17

Whate *exactly* are you trying to achieve with your macro?

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


"dplaut" <dplaut@discussions.microsoft.com> wrote in message 
news:FACC88A6-8D2B-4AD9-9101-2C5C513B1B33@microsoft.com...
> If I put a font combo box on a Ribbonbar is there a way for me to capture 
> the
> user's font choice? I need to capture that choice and use it in a macro. 


0
Graham
3/2/2010 6:55:52 AM
I want to get the font the user wants to use but then I need to apply that 
font in multiple places such as the header of the document as well as where 
the cursor is located.

My current solution is to open a font dialog w/ code like:
Set dlgFonts = Dialogs(wdDialogFormatFont)

But now I've found that I can put a font combo box on the ribbonbar, that 
would be a more appropriate interface as it does not have the myriad of 
formatting choices that the font dialog has. I just want to get the name of 
the font the user wants.

"Graham Mayor" wrote:

> Whate *exactly* are you trying to achieve with your macro?
> 
> -- 
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor -  Word MVP
> 
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> 
> 
> "dplaut" <dplaut@discussions.microsoft.com> wrote in message 
> news:FACC88A6-8D2B-4AD9-9101-2C5C513B1B33@microsoft.com...
> > If I put a font combo box on a Ribbonbar is there a way for me to capture 
> > the
> > user's font choice? I need to capture that choice and use it in a macro. 
> 
> 
> .
> 
0
Utf
3/8/2010 2:11:01 PM
Reply:

Similar Artilces:

Rename User Problem
We have a user that has gotten divorced. I have renamed her account and everything else yet she still shows up with her old name in one place. Example: Old name: Missy Oldname = moldname as her username. She used to show up like Missy Oldname <moldname> in the address list dropdown. Renamed everything to: New name: Missy Newname = mnewname as her username. She still shows up in the address list as Missy Newname <moldname> in the address drop down list. The strange thing is you can search for her name by typing mo and it brings up her email name in the to: field. You type mn...

Random selection #2
How can I set a random selection based on a set number of records in Excel, without repeating the selected record? I have a column with a list of individual names and another column with list of countries. I want to randomly select a country in the 2nd column and assign it to the person's name in the 1st column. However, once the first selection is made I cannot use that country name again for the second selection, and so on. An example that describes what I want to do is when we select names from a hat for gift exchange during holidays. It is a set of specific names, and they will no...

email capture
I'm having a problem with Outlook not pulling the mail off my pop server. When I do a send and receive the mail is identified, "grabs" the messages like it's doing a download but when it reaches the end I'm getting an unknown error message. Any thoughts? 1) First, try to set up Outlook Express to download the email set. Sometimes it has better luck. 2) Another way is to clear the queue manually. This is technical, and not really recommended by anyone, but you may have a stuck message... Telnet to get it... (this method permanently deletes messages before you c...

Median of Even Set; How to Capture them?
Hi everyone, Say I have a dat set such as: 4 5 6 7 The median is (5+6)/2=5.5! However, I am not interested in the answer here, but the 5 and the 6!!! Is there an excel function or way to do so? Thanks alot, Mike Do you want the output in one single cell or in 2 separate cells? Mike Wrote: > Hi everyone, > > Say I have a dat set such as: > > 4 > 5 > 6 > 7 > > The median is (5+6)/2=5.5! > > However, I am not interested in the answer here, but the 5 and the > 6!!! > > Is there an excel function or way to do so? > > Thanks alot, ...

Cannot add users through web client
I recently installed CRM at a client site and ran into the issue where I cannot add users (logged in as the administrator) through the web client. I can however add users via the deployment manager. Has anyone run across this issue? The error message is very generic (error has occurred, contact your network administrator) and occurs after I enter the user name of the person I'm trying to add, and CRM attempts to populate based on active directory. Something is wrong. What version? v3.0 or v1.2? Has the latest update rollup been installed? Was this a clean install? or multip re-i...

Capture user selection of font
If I put a font combo box on a Ribbonbar is there a way for me to capture the user's font choice? I need to capture that choice and use it in a macro. Whate *exactly* are you trying to achieve with your macro? -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "dplaut"...

Storage limitations on user mailboxes
OK This is part of a two part question. Where does one look or check to see if there are any limitations as far as storage on a individual mailbox or the whole private store? Second is there a limitation as far as how many emails can reside in the users "Inobx" where senders will get a NDR indicating the users mailbox is full. Ive checked ESM\Servers\servername\First Storage Group\Mailbox Store\Properties. I had a user who would get NDR's when "forwarding" messages. I noticed her "Sent" mail had over 2,400 emails so I deleted some and got it down to aro...

Attach a Mail Store to Another User
Background: Some people have left the company, and I want their managers to have easy access to the ex-employees mail store. Question: How can I attach one (defunct) user's mail store to another user? Naturally, I will add an alias to the manager's email account list so that future mail will go directly to him/her, but I need to know how to give access to the ex-employee's mail store so the manager can read the old mail from Outlook. By the way, if at all possible, the solution should not require the ex-employee to remain on the global address list. Thanks! v-tech On 10 Oct 2...

List of Users
i am creating a report where i need list of user belongs to a particular team. but i did not find (TeamId) in filteredUserSettings. Please help me to get user list(names) form crm database. thanks in advance !!!!!!!!!!!! On Jan 29, 5:33=A0am, Mahain <mahende...@gmail.com> wrote: > i am creating a report where i need list of user belongs to a > particular team. but i did not find (TeamId) in filteredUserSettings. > > Please help me to get user list(names) form crm database. > > thanks in advance =A0 !!!!!!!!!!!! Hi Mahain, There is a filteredteammembership view w...

Positioning 2 User Forms
Hi I hope I explain this correctly - I have user form 1 which on opening fills the monitor screen with everything in its correct place and working OK. Within the same Workbook I have a small user form 2 which is opened by a command button on user form 1. On opening that works perfectly OK. However no matter what I try and do and that includes changing Start Up Position = in the VBA the damn thing always opens in the middle of user form 1 - when the desired position would be in an empty space available on the baseline of user form1. Any help and suggestions would be much appreciated ...

How to select series in chart?
I know I asked this question before, but (sigh) I cannot find the answer now, when I need it of course. How can I select a series in an Excel chart (XY Scatter) using the keyboard, not the mouse? The issue is: I have overlapping series, so it is difficult for me to select a series by moving the mouse cursor to a point in one series and right-clicking it, as I normally do. Someone once mentioned a ctrl and/or shift key combination (I think) that would allow me to select each series explicit in round-robin fashion. That is what I am looking for again. More generally, how could I have found...

Restore "classic" search for all users
Hello, Windows XP Pro, SP3 I have a new install and want to change the unpleasant standard Windows XP search assistant to the classic one. I have done this in the past by creating an entry "Use Search Asst" REG_SZ (String Value) in the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\CabinetState and setting the value to "no" But my new system has 5 user profiles. Will I have to change this setting for each user profile? Is there a way to change to classic search assistant for all users? Many thanks. Jack ...

cannot find "Exchange Task" in Active Directory Users and Computers console
I have.. 1st AD - W2k 2nd AD - W2k with Exchange 2K. I cannot find "Exchange Task" in Active Directory Users and Computers console of 1st AD or other workstaions with domain admin pak loaded. I can ONLY perform exchange task on 2nd AD with Exchange. It's so inconvenient. What am I missing here? Thanks Calvin you need to install the ESM on the workstation... "Calvin C." <CChang@mjlm.com> wrote in message news:eF1yHJYrEHA.192@tk2msftngp13.phx.gbl... > I have.. > 1st AD - W2k > 2nd AD - W2k with Exchange 2K. > > I cannot find "Exchange ...

Change Data Capture: Preserve capture instance data when adding co
When a new column is added to table that is configured for change data capture (cdc), the capture instance table will not have the new column until cdc is disabled and re-enabled for the source table. In the process the existing capture instance is dropped. I thought I could copy existing data out to a temp table and then copy back using the following SQL. However, other CDC meta information, such as the cdc.change_tables.start_lsn, becomes invalid. How can the capture instance history be preserved, using the same capture instance name, if at all? Thanks, Rich /*...

Outlook XP won't start for 1 user on a 5 user system
SSdtIHJ1bm5pbmcgV2luWFAgU3AxYSB3aXRoIE9mZmljZSBYUC4gVGhlcmUgYXJlIDUgdXNlciBh Y2NvdW50cy4gNCBvZiB0aGUgNSBjYW4gYWNjZXNzIE91dGxvb2sgd2l0aCBubyBwcm9ibGVtcyBv dGhlciB0aGFuIGFuIGludGVybWl0dGVudCBDKysgZXJyb3IsIHdoaWNoIG5ldmVyIGhhcHBlbnMg dHdpY2UgaW4gYSByb3csIHNvIHdlIGp1c3QgcmVzdGFydCBhbmQgYWxsIGlzIHdlbGwuDQoNClRo ZSA1dGggdXNlciBjYW5ub3QgZ2V0IE91dGxvb2sgdG8gc3RhcnQuIFRoZSBzcGxhc2ggc2NyZWVu IGNvbWVzIHVwLCB0aGVuIHRoZSBtYWluIHdpbmRvdyBiZWhpbmQgaXQsIGZvbGxvd2VkIGJ5IGFu IGV2ZXJsYXN0aW5nIGhvdXJnbGFzcy4gSXQgaGFzIHRyaWVkIHRvIHN0YXJ0IGluIHNhZmUgbW9k ZSB3aXRoIHRoZSBzYW1lIHJlc3VsdC4gSXQgaGFzIGFza2VkIGlmIEkgd2Fud...

Selection of date range
I have a small table that covers an entire year of sales I need to make a way to select he date range, and sales Agent type and display the pounds purchased for that week. So I'd like a selection box "enter Date range" (weekly) & type of Customer Affiliate Domestic, Affiliate international, Domestic Customers, International Customers. Should be simple, eh? Any advice? Just add a little form with 2 textboxes: txtStart and txtEnd Then use the following query criteria: For the dates: Between Forms!FormName!txtStart And Forms!FormName!txtEnd...

Business Portal External User licensing
Hello: We're going to be utilizing the extranet feature of BP 3, but I need to know exactly what I am going to need in terms of licensing. I know I will need an SBS CAL for each external user, but what else am I going to need? I remember reading that I would need an external user license for the Portal itself. Is that right? Do I have to buy one for each user that is going to be logging in? They're just going to be accessing reports, viewing the online product catalog, and using Order Management to place orders from the field. Thanks in advance for any information. -Joe Joe, ...

Long Reconnect Times w/Multi-Users?
This is a variation on my prior attempt at a thread "App Runs Slower w/2 Users Than w/1?". Front end on C:, back end on a LAN file server. Code to reconnect tables runs in about 2.5 seconds when I'm the only one logged in to the front end. But when one other person has their copy of the front end up and running, that same re-connect process takes 207 seconds. It's not a religious issue bc the only time that process runs is when I prep the front end for distribution before elevating a new version. OTOH, if the reconnects are that slow... I wonder if the rest of the app is...

MS Office has not been installed for the current user.
I have installed MS Office Home and Student 2007 that I have purchased. It had been working fine for about 1 month on my Win laptop7 Now I can't open any of my MS Word docs. I get the message MS Office has not been installed for the current user. Can anyone help with a fix? Bill Did you have an Office 2007 Trial installed before at any time and did you uninstall it before installing your purchased version of Office 2007 H&S -- Peter Please Reply to Newsgroup for the benefit of others Requests for assistance by email can not and will not be acknowledged. "Bill"...

see messages in user's maibox
Is there a way, other than Outlook and OWA, to see/look into a user mailbox? The Tracking of a message will not give the message text - right? I need to review all e-mail that has been sent or received by a user - how do I do that? Without using Outlook or OWA. Thx Correct - message tracking will not display message content. Journaling - will dump all mail to a journaling mailbox for all users of a store. Custom apps/scripts can be used if you have permissions on the target mailbox(es). -- Bharat Suneja MCSE, MCT -------------------------------- "John Leonard - Sage" <...

user/passwords
Hi, just a basic question and hopefully a simple solution. Basically I want to have a user/pass box that, when the data is correct, takes you to a worksheet. I have searched the forums/site and havent found anothing usefull. I have tried using macros and cutting up some vb code that looked..interesting..but none worked. TIA :) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ The user is offered the choice to disable macros or can hold down the shift key when the workbo...

Combining Font Types
Is there a way to combine two different font styles for display as the Label.Caption on a user form? I need to concatenate a character from the 'Symbol' set with a standard letter (A-Z) and display the combination as the ..Caption for a form label. But the font description (Arial) for the label replaces the 'Symbol' character with the Arial equivalent. Is there any way to display two different font styles together? -- Bill @ UAMS Try this. Type abcdefg in a cell Now highlight just the D and change the font to symbol You should see abs<delta>efg; where ,delta. i...

Empty Users Mailboxs ?
I want to empty about 1200 mailbox of users belong to 4 groups ? they all exist in one store On Thu, 20 Jul 2006 04:51:02 -0700, Mbrando <Mbrando@discussions.microsoft.com> wrote: >I want to empty about 1200 mailbox of users belong to 4 groups ? >they all exist in one store http://support.microsoft.com/kb/319188 "How to use recipient policies to control mailboxes in Exchange 2000 and Exchange 2003" If you want to completely clean out all the mailboxes on a particular mailbox store, simply dismount the store, and delete (or rename if you're the slightest bit ...

Exchange Users
does any one know how to empty select simgle users inbox, so you select 1, i have found you can do them all but i cant find how to do 1 ...

Capture signature
I have a Ingenico 6550 signature capture device. When i sign on the device, it didn't capture the name. The display and the card capture worked, only the signature part doesn't work. I set the device name and everything, it loaded the form, and the tab for the signature on the pos poped up. I use the form designer to test the capture device it worked. The signature show on the form designer. I don't know what could go wrong. Could anyone help!!! By the way i am using RMS 1.3. "TJW" wrote: > I have a Ingenico 6550 signature capture device. When i sign on...