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