Longer drop-down menu for Data Validation list in Excel

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