Combo Box with vertical scroll bar

[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.

 

[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'.

 

[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.

 

[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.

 

[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