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.

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


.

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

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 ?

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 ?