Combo Box with vertical scroll bar

V

VJ

Is there anyway I can add the vertical scroll bar to combo box?

The reason I am asking is because I have name range assigned to
..ListFillRange... property of the combo box but the user only see which fits
on the computer screen but I want to display the vertical scrool bar so they
can see and scroll the ones which doesnot fit.
 
G

Gary Brown

It should automatically appear when the list gets bigger that the 'ListRows'
property.
UNLESS the 'Style' property isn't properly set. Make sure the 'Style'
property is set to 'frmStyleDropDownCombo'.
 
V

VJ

Hello Gary,

Thanks for your efforts.

But it didn't work. My combo box alread has the style property set to
'frmStyleDropDownCombo'.

Is this excel issue?

Any trick I have to do programatically to make it dynamic big.
 
V

VJ

Hi Gary,

I recreated the combo box control from scratch. This time it seems fine.

Do you know how can I set the number of rows to show instead of 10 to 20? I
mean how can increase the number of rows a user can see while clicking on the
combo box.

I hope my question is clear.
 
G

Gary Brown

The 'ListRows' Property of the Combobox specifies the maximum number of rows
to display in the list.

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top