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

  • Thread starter Thread starter Oscar
  • Start date Start date
O

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 ?
 
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.
 
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.
 
Back
Top