data validation list font size

[Maggie]

Can you change the font size of the data validation list
as it appears in the drop-down? The font is very small. I
increased the font size in the original list, but it does
not seem to carry through to the drop-down version.
Thanks!

 

[Anne Troy]

The only way I'm aware of to accomplish this is to increase your view
percentage. That's it.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[Frank Kabel]

Hi
this can't be done but the following site has a workaround:
http://www.contextures.com/xlDataVal08.html#Larger

 

[Jason Morin]

MVP Debra Dalgleish has some VBA code on her site to
adjust the zoom when the data validation is activated:

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

HTH
Jason
Atlanta, GA