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



"VJ" wrote:

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.

"VJ" wrote:

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.

"Gary Brown" wrote:

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'.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"VJ" wrote:

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.