PDA

View Full Version : Drop-down list increase viewable items without scrolling



jwood
07-01-2017, 12:06 PM
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
07-01-2017, 02:18 PM
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
07-01-2017, 07:14 PM
Your drop-down list is Data Validation?

JKwan
07-03-2017, 05:51 AM
When you say "Drop down list", I am assuming a Combobox


Me.ComboBox1.ListRows = 20