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


"Dutch Driver" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>