Drop Down list font too small... help please

[Mike]

Hi all,

I have a drop down list - well many actually that are working fine....
except that the values in the drop-down list are literally too amall
to read (at least for me!!!).

The choice selected will display correctly ( font size etc. ) in the
correct cell, but a fter clicking the arow in the cell to access the
drop-down list, the values in that list are approx a font size 8 -
instead of 12. Once chosen the valus appears correctly.

How do I force the displayed font in the drop-down list to be larger?

TIA

Mike

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal08.html#Font

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ron Coderre]

Debra Dalgleish covers the drop-down list font-size issue on her website:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Mike]

Thanks to all - that is actually very cool ....

IS there a way to get it to return to the default zoom level ---
whatever the user has previously chosen ?

Awesome & quick - thanks

Mike

 

[Don Guillett]

oldzoom = ActiveWindow.Zoom
do your thing
activewindow.zoom=oldzoom