Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, I placed a drop-down box (Combo Box) on one of my sheets and am trying to
figure out how to change the font size within the box. When I right click and go into the control properties it doesn't give me an option to change the font. If I select the control and then go up to the font size the font is greyed out. This seems like it would be very simple to do, but I can't figure it out. Any help would be appreciated. Thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi,
in design mode, right click the control. Scroll down to and click into the box to the right of the word font. A small square will appear in the box. click it and the font properties dialog box will appear. controls have their own fonts. the fonts on the tool bar are for sheet fonts. Regards FSt1 "James C." wrote: Hi, I placed a drop-down box (Combo Box) on one of my sheets and am trying to figure out how to change the font size within the box. When I right click and go into the control properties it doesn't give me an option to change the font. If I select the control and then go up to the font size the font is greyed out. This seems like it would be very simple to do, but I can't figure it out. Any help would be appreciated. Thanks |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I right click on the control the options that it gives me a
- Cut - Copy - Grouping - Order - Assign Macro - Format Control That is it, within format control there is no place to select Font? Am I missing something? "FSt1" wrote: hi, in design mode, right click the control. Scroll down to and click into the box to the right of the word font. A small square will appear in the box. click it and the font properties dialog box will appear. controls have their own fonts. the fonts on the tool bar are for sheet fonts. Regards FSt1 "James C." wrote: Hi, I placed a drop-down box (Combo Box) on one of my sheets and am trying to figure out how to change the font size within the box. When I right click and go into the control properties it doesn't give me an option to change the font. If I select the control and then go up to the font size the font is greyed out. This seems like it would be very simple to do, but I can't figure it out. Any help would be appreciated. Thanks |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You need to use the combobox from the control toolbox toolbar, not the forms
toolbar. Right click and select properties and you will see the font option there -- Regards, Peo Sjoblom "James C." wrote in message ... When I right click on the control the options that it gives me a - Cut - Copy - Grouping - Order - Assign Macro - Format Control That is it, within format control there is no place to select Font? Am I missing something? "FSt1" wrote: hi, in design mode, right click the control. Scroll down to and click into the box to the right of the word font. A small square will appear in the box. click it and the font properties dialog box will appear. controls have their own fonts. the fonts on the tool bar are for sheet fonts. Regards FSt1 "James C." wrote: Hi, I placed a drop-down box (Combo Box) on one of my sheets and am trying to figure out how to change the font size within the box. When I right click and go into the control properties it doesn't give me an option to change the font. If I select the control and then go up to the font size the font is greyed out. This seems like it would be very simple to do, but I can't figure it out. Any help would be appreciated. Thanks |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Peo. I missed that.
regards FSt1 "Peo Sjoblom" wrote: You need to use the combobox from the control toolbox toolbar, not the forms toolbar. Right click and select properties and you will see the font option there -- Regards, Peo Sjoblom "James C." wrote in message ... When I right click on the control the options that it gives me a - Cut - Copy - Grouping - Order - Assign Macro - Format Control That is it, within format control there is no place to select Font? Am I missing something? "FSt1" wrote: hi, in design mode, right click the control. Scroll down to and click into the box to the right of the word font. A small square will appear in the box. click it and the font properties dialog box will appear. controls have their own fonts. the fonts on the tool bar are for sheet fonts. Regards FSt1 "James C." wrote: Hi, I placed a drop-down box (Combo Box) on one of my sheets and am trying to figure out how to change the font size within the box. When I right click and go into the control properties it doesn't give me an option to change the font. If I select the control and then go up to the font size the font is greyed out. This seems like it would be very simple to do, but I can't figure it out. Any help would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change font in a forms control combo box | Excel Discussion (Misc queries) | |||
Can one combo box control the data in a different combo box | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) |