Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default Font for Combo Box Control

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Font for Combo Box Control

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default Font for Combo Box Control

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Font for Combo Box Control

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Font for Combo Box Control

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change font in a forms control combo box JRTB Excel Discussion (Misc queries) 3 February 25th 09 09:34 PM
Can one combo box control the data in a different combo box MarkM Excel Discussion (Misc queries) 5 October 9th 06 11:44 AM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 1 February 16th 05 02:05 AM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 0 February 15th 05 07:45 PM
Control Tab from Combo box- format control missing!! Mo Excel Discussion (Misc queries) 3 January 7th 05 01:09 PM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"