Drop down list

[Hrider]

When I create a drop down list for a cell the font is too small. How can I
increase the size so I can read it better?

 

[Gord Dibben]

See Debra Dalglesih's site for instructions on increasing the view size of a
DV drop-down list.

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


Gord Dibben Excel MVP

 

[Debra Dalgleish]

You can't change the font or font size for a Data Validation dropdown
list. To make the font appear larger, you can use programming to adjust
the zoom setting when the cell is selected. There's sample code here:

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

Or, there's a sample file here that provides a combobox from which you
can select one of the values from the data validation list. In
thecombobox, you can set the font size:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Data Validation Combobox'