Hello,
Is there a way to get a longer (taller) drop-down options menu when using a Data Validation list in Excel?
I have a spreadsheet in which one of the column headings is "Event Type". In a different spreadsheet (but the same workbook) I defined a range of cells with the name "EventTypes". I then applied Data Validation to the first column by selecting List (Settings > Validation criteria > Allow) and "=EventTypes" as the Source.
The EventTypes range currently has almost 20 entries but when the drop-down menu is opened, only eight of the options are displayed and vertical scrolling is required to see the remainder.
Is there an Excel setting which will enable the drop-down menu to be long enough to display all options and eliminate the scrollbar? If not, is it doable using VBA or another method?
By the way, I found a similar question here:
Way to incorporate more than Eight Items in Data Validation drop down in which the accepted solution says the drop-down menu length
cannot be increased but that an alternative is to use a VBA ComboBox.
Is that reply (re menu length) correct? And if so, how do you create a VBA ComboBox?
Thanks
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.