How can I get a larger list height for a combobox while drop down ?

[Oscar]

I am using a combobox at a worksheet. The height of the list that is shown
while drop down is far too small which enforces always to scroll through the
list. How can I get the list height larger ?

 

[Guest]

hi,
i don't think you can. you may want to consider switching
to a list box. they work about the same but are sizable.
they do take up more space on the sheet. avantages and
disavantages.

 

[Debra Dalgleish]

If you're using a combobox from the Forms toolbar, right-click the
combobox, and choose Format Control.
On the Control tab, increase the number of drop down lines.

If you're using a combobox from the Control toolbox, click the Design
mode button on the Control toolbox
Select the combobox
Click the Properties button on the Control toolbox
Increase the number in the ListRows property.

 

[Tom Ogilvy]

Set the ListRows property to the number of rows that you want visible.

 

[Oscar]

Thank you all,

this was what I was looking for.

regards,
Oscar