Drop Down List Woes

[kmwhitt]

I have a drop down list in excel 2000 (data validation) whose contents
cannot read. If I make the entire column width wider, I throw off th
whole page layout. Is it possible to widen the drop down list withou
changing the entire column width? Also, how do I change the font o
this list?

Thanks,

Kevi

 

[Debra Dalgleish]

You could use a SelectionChange event to temporarily widen the column.
There are some instructions here:

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

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 some sample code here:

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