Text Size in Dropdown

[Randy Vieira]

Is there any way to control the size of the text in a list controlled
validation drop down box? I have quite a long list to shown and my text is
microscopic. I've searched the group and didn't see anything. Even when I
zoom to 100%, the text is still too small.

TIA,

Randy

 

[Debra Dalgleish]

As answered in microsoft.public.excel:

In data validation dropdown lists, you can't change the font size. There
are a couple of workarounds here:

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