Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to increase font size in drop-down controll
I have a work sheet with a drop down meny where the font is too small.
There are no properties option when right clicking the dropdown meny. (There is the option of format controll, but this option does not give you the opertunity to change the font.) Thanks for any help with this problem. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to increase font size in drop-down controll
If the worksheet is using a Data Validation list, the list takes on the
formatting of the font assigned to the cell the validation list is placed in. If the drop-down list is using he combo box control from the Control Toolbox, the font size is modified by placing the document in design mode using the Control Tool Box Desigin Mode button, right clicking on the combo box and selecting Properties. Locate the font property field, click to activate the field and then click on the button with an ellipsis (...) to go to the font menu. -- Kevin Backmann "Iver" wrote: I have a work sheet with a drop down meny where the font is too small. There are no properties option when right clicking the dropdown meny. (There is the option of format controll, but this option does not give you the opertunity to change the font.) Thanks for any help with this problem. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to increase font size in drop-down controll
Iver, It sounds like you are using a Form and not a Control. Replace your Form list box with a Control list box. When you right mouse click on the Control, you will see a properties option. Select that and then where it says font in the properties list, click on that and your formatting options will appear. Select the larger font size etc... This is also where you link the list range as well. Once you are done formatting, exit the VBA design mode to activate your Control. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=506331 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you increase the font of the drop downauto filter | Excel Discussion (Misc queries) | |||
Font size in data validation drop down lists | Excel Discussion (Misc queries) | |||
Drop Down List Font Size in Data Validation | New Users to Excel | |||
Autofilter - can I increase the drop down font | Excel Worksheet Functions | |||
How do I increase type size in an Excel drop down list? | Excel Discussion (Misc queries) |