How to increase font size in drop-down controll

[Guest]

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.

 

[Guest]

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.

 

[SteveG]

Iver,

It sounds like you are using a Form and not a Control. Replace you
Form list box with a Control list box. When you right mouse click o
the Control, you will see a properties option. Select that and the
where it says font in the properties list, click on that and you
formatting options will appear. Select the larger font size etc...
This is also where you link the list range as well. Once you are don
formatting, exit the VBA design mode to activate your Control.

HTH

Stev