Data Valadation

[Ray]

Hi,
I have a user that has created data valadation from a
list. Now she wants to change the font size in the drop
down box. I have tried changing the font in the original
list. She insists on the valadation not a combo box.
TIA
ray

 

[Jason Morin]

AFAIK, it's not possible. One workaround is to increase
the zoom when the validation is activated. MVP Debra
Dalgleish has some code for that:

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

HTH
Jason
Atlanta, GA

 

[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 on my web site:

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