Changing font size in data validation drop-down lists

[Dutch Driver]

In Excel 2003, I created the value list on a separate worksheet and labled
the range so I could use it in the data validation wizard on a different
worksheet.

The list is working fine; however, the font size in the drop-down list is
too small to comfortably read.

So far, I have tried:
Making the font in the list larger.
Formatting larger font size in the active cell with the drop-down button
And, creating the list on the same worksheet.

All three remedies have not increased the size of the font in the drop-down
list.

Suggestions are welcome.

Great Optimism,

Dutch Driver

 

[Peo Sjoblom]

There is no way of changing the fonts using validation, Debra Dalgleish has
a method here

http://www.contextures.com/xlDataVal08.html#Font



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey