Drop-down list increase viewable items without scrolling

[jwood]

I'm working with an older version of Excel, 2003. I've created some drop-down lists. I know how to add or remove items from the lists. What I want to do, though, is to extend
the number of items that are seen when opening the list from within the cell. Right now, the default seems to be only 8 items. To see the rest, you must use the scroll bar which becomes a hassle if you have to do it often enough. Some of my lists I would want to have show 10 items. Some 15. Without scrolling. Anyone know how to do this? Probably everyone.

Thanks, Jack

[SamT]

Determine the height On Points of a single entry + vertical White Space

Const SEHeight  As Long = ???

'Add Entries, then
ListBox1.Height = (ListBox1.ListCount * SEHeight) + FudgeFactor ' I dunno FF value. Experiment

[mana]

Your drop-down list is Data Validation?

[JKwan]

When you say "Drop down list", I am assuming a Combobox

Me.ComboBox1.ListRows = 20