User Form /COMBO BOX 1

[lee2boy]

Gents can you help please,
I'm trying to increase the amount of lines in my Combo box, when you push the drop down box it will only show six lines.
I have altered in the properties box for the Combo box originlly to 20 and no change i then reduced to 9 thinking possiblely this would be the max but still no change.
Please Can any body help chaps.
I have attatched a screen print to show what I mean
I would be grateful for any helps chaps
Regards
Lee

[CodeNinja]

Lee,
Check out Combos with tens of thousands of records
(http://allenbrowne.com/ser-32.html)

[Tinbendr]

The rowsource only has six rows. It won't show empty rows if you increase the Listrow beyond the number assigned to the box.

[Rob342]

Lee
Why dont you use a dynamic named range the list is a long or short as you want.