How can I magnify a dropdown list such that its visible area is larger than the cell itself?
C courtesio99 Dec 11, 2003 #1 How can I magnify a dropdown list such that its visible area is larger than the cell itself?
B BrianB Dec 11, 2003 #2 By making a custom DropDown (?) - preferably using the Forms toolbox. The one in the Controls toolbox has more options, but is prone to bugs.
By making a custom DropDown (?) - preferably using the Forms toolbox. The one in the Controls toolbox has more options, but is prone to bugs.
D Debra Dalgleish Dec 11, 2003 #3 For a data validation dropdown, you could use a SelectionChange event to temporarily widen the column. There are some instructions here: http://www.contextures.com/xlDataVal08.html#Wider
For a data validation dropdown, you could use a SelectionChange event to temporarily widen the column. There are some instructions here: http://www.contextures.com/xlDataVal08.html#Wider