Questions About ComboBox
 

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?

--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

Questions About ComboBox
 

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

Questions About ComboBox
 

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)


"Chaplain Doug" wrote in message
...
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?

--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

Questions About ComboBox
 

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.

"Chip" wrote:

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