Need to increase the size of text in a drop-down box
 

I have a spreadsheet with large font, however the drop boxes I am using have
very small (standard??) fonts inside them making them undreadable unless you
change the zoom back to 100%. Is there a way of increasing the font size of
the list in the drop down box?

Need to increase the size of text in a drop-down box
 

Not if it is a validation list, Debra Dalgleish has code that will zoom

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

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"CPMA" wrote in message
...
I have a spreadsheet with large font, however the drop boxes I am using
have
very small (standard??) fonts inside them making them undreadable unless
you
change the zoom back to 100%. Is there a way of increasing the font size
of
the list in the drop down box?