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?