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 he
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'
RL wrote:
I have validated cells in my worksheet, which allow lists. I want to resize
the lists that pull down when the cell is selected...any tips?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html