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

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 ?

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

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.

-----Original Message-----
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 ?


.

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

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.


Oscar wrote:
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 ?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

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

--
Regards,
Tom Ogilvy

"Oscar" wrote in message
...
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 ?

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

Thank you all,

this was what I was looking for.

regards,
Oscar

"Tom Ogilvy" schreef in bericht
...
Set the ListRows property to the number of rows that you want visible.

--
Regards,
Tom Ogilvy

"Oscar" wrote in message
...
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 ?