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