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

On Fri, 11 Jan 2008 12:06:01 -0800, MMouse
wrote:

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.