Questions About ComboBox

[Guest]

I have added a combobox to an Excel sheet. The values for the list are set
programmatically by placing them in cells in the worksheet.

1. There are 71 or more values that I need to appear in this combo list.
Only 40 of them appear on the screen when I open the combo list. How can I
get a vertical scroll bar on the list so that I may get to all the values in
the list?

2. Is there another way to specify the list values other than placing them
in cells in the worksheet and setting the ListFillRange?

 

[Chip]

Do you have the range in the list fill set to encompass all 70 items?
You can check by right clickin on the drop down>Format Control, and
seeing the input range. If the answer is yes, then post your code.

 

[Bob Phillips]

You should automatically get a scrollbar. Where is the combobox from, the
forms toolbar or the control toolbar?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

My problem was that I was setting ListRows to the number of items in the list
each time, so there was no scroll and lots of items off the screen. I
hardcoded ListRows=12 and I get the scroll bar. Thanks.