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
"Dutch Driver" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>