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.
> > > >
|
Similar Threads
