how do you change the font size of a drop-down list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I use the Validation feature under Data Menu and I create a drop-down
list, the font size of the contents of the drop-down list is too small to
read. How do I change this?
 
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 the
combobox, you can set the font size:

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

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