PDA

View Full Version : Solved: Combobox items



JKwan
09-30-2010, 10:05 AM
Is it possible to increase the number of items being displayed with a combobox? With the combobox ActiveX control there is a .DropDownLines that I can set, however, there is none for the forms combobox control. The default is to display 8 items, I would like to increase the number of items to display more.

Bob Phillips
09-30-2010, 10:10 AM
In Properties>Control, there is a box for number of Drop-down lines.

JKwan
09-30-2010, 10:12 AM
In Properties>Control, there is a box for number of Drop-down lines.

That is set for using ActiveX, however, with a userform, that property does not exists.

Bob Phillips
09-30-2010, 11:18 AM
No, it is set for the worksheet forms combobox.

If you mean a userform combobox, it is the ListRows property.

JKwan
09-30-2010, 11:51 AM
Thank you, that is what I was looking for. Why do MS call them differently with the "same" controls.....

Bob Phillips
09-30-2010, 12:08 PM
That is a good question; one for which I have no real answer. My guess is that it is such a huge company, competitive siloing is probably encouraged, and there is no over-arching co-ordination.