Formatting drop-down menus

  • Thread starter Thread starter Lorne
  • Start date Start date
L

Lorne

How do you change the size of font used to display options in a drop-down
menu placed on a spreadsheet?

I have tried formatting the default font size for the spreadsheet & the font
size in the cell range used for the drop-down menu options but neither
worked and I can't find anything in the help files.

Windows XP home, Office 2000 Premium, All updates installed.
 
The drop-down menu I am using is a combo box rather than a data validation
list.

Is the same thing true about font sizes?
 
If it's a combo box from the Forms toolbar, you can't change the font
size. If it's a combo box from the Control Toolbox, you can open its
property window, and change the font settings.
 
Back
Top