C courtesio99 Dec 11, 2003 #1 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?
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?
B Bill Manville Dec 11, 2003 #2 Courtesio99 said: How can I magnify a dropdown list such that its visible area (width) is larger than the cell itself? Click to expand... Is this a data validation in-cell dropdown, or a Forms toolbar dropdown? If so, you don't. With a Control Toolbox dropdown you can set the ListWidth property. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup
Courtesio99 said: How can I magnify a dropdown list such that its visible area (width) is larger than the cell itself? Click to expand... Is this a data validation in-cell dropdown, or a Forms toolbar dropdown? If so, you don't. With a Control Toolbox dropdown you can set the ListWidth property. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup
D Debra Dalgleish Dec 11, 2003 #3 As answered in .misc -- 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
As answered in .misc -- 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
