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

On Thu, 18 Sep 2008 07:00:01 -0700, Phil B.
wrote:

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