As answered in .misc --
For a data validation dropdown, you could use a SelectionChange event to
temporarily widen the column. There are some instructions he
http://www.contextures.com/xlDataVal08.html#Wider
courtesio99 wrote:
How can I magnify a dropdown list such that its visible area (width) is
larger than the cell itself?
Is there an code for this?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html