ExcelBanter - Text Size in Dropdown

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text Size in Dropdown (https://www.excelbanter.com/excel-discussion-misc-queries/9995-text-size-dropdown.html)

Text Size in Dropdown

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

As answered in microsoft.public.excel:

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

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

Randy Vieira wrote:
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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html