Combo Box with vertical scroll bar
 

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.

Combo Box with vertical scroll bar
 

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.

Combo Box with vertical scroll bar
 

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.

Combo Box with vertical scroll bar
 

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.

Combo Box with vertical scroll bar
 

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.