Using combo boxes

[Disco]

I am trying to use a combo box control to access a list of
data.
i am having problems 'pointing' the combo box to the list
of data I would like to use.
Where do I tell the box where to look ???

thanks

PS I cannot use the 'forms' combo box as this has does not
allow me to type in the combo box.

 

[Wild Bill]

Look at the Listfillrange property.

 

[Harald Staff]

Hi

It's the ListFillRange property of the box. Unless it's on a userform, then
it's called RowSource, for some odd reason.

 

[Disco]

Thanks a lot guys!!! Finally figured out what happened. Instead of the
combo box under "Control" toolbar, I need to use the combo box under
"Form" toolbar.

Now I want to populate the combo box. These values are coming from
cells under a col on a worksheet. Not only do the values change from
time to time but also the number of values change. If I set the cbo
source range equal to the whole col the combo box will contain tons of
blank selections. Is it possible to only grab the non blank values from
the cells and put them into the combo box to avoid blank selections?

Thanks a lot.

Rex