ListBox Drop Down Font Size

[Phil B.]

When developing a List Box using "Data/Validation" (Excel 2002), the drop
down text font is very small. How can you change this font size?
Thanks

 

[Gord Dibben]

With DV dropdowns you cannot change the font size.

See Debra Dalgleish's site for workarounds.

http://www.contextures.on.ca/xlDataVal08.html#Font


Gord Dibben MS Excel MVP

 

[Phil B.]

Thanks. The Dalgleish workarouds will work for me.