troubleshooting Question

Longer drop-down menu for Data Validation list in Excel

Avatar of WeThotUWasAToad
WeThotUWasAToad asked on
Microsoft ExcelMicrosoft Office
8 Comments3 Solutions2089 ViewsLast Modified:

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?

Join our community to see this answer!
Unlock 3 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros