Drop Down List Size

[MMouse]

My drop down list appears with a very small font. how can I get my drop down
to appear with the same size font I'm using in my cells, or perhaps even
larger? Some of my users are over... a certain age.... and well, cant' view
those tiny letters.

 

[Gord Dibben]

You cannot change the DV list font-size.

See Debra's site for a workaround using event code which zooms when the DV cell
is selected.

When a selection is made, the code unzooms.

http://www.contextures.on.ca/xlDataVal08.html#Larger


Gord Dibben MS Excel MVP