Font in validation drop-downlist

[Trond]

I have a validation drop-down list in a cell and since my
sheet is big, I've zoomed it to 50%. When I want to select
an Item from the list the font is so small that I can
hardly read it. Can I change the font in the drop-down
list?

Trond

 

[Frank Kabel]

Hi
you can't change the font of the valdiation listbox. But
see the following site for a workaround:
http://www.contextures.com/xlDataVal08.html#Larger

 

[Debra Dalgleish]

You can't change the font size for a Data Validation dropdown list.
However, you can use programming to adjust the zoom setting when the
cell is selected. There's some sample code here:

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