I think I just worked it out about 60 seconds after placing the post. I was
on the right track.

not sure if it is the best way, but I have used:

..rowsource to link the the source data
..columncount to make sure the correct number of rows are displayed
and counta on the sheet to count the number of rows that need to be
displayed, as this will change.
I am now going to link the .columncount and the value from the counta formula.

It looks like this is going to work.

"beauty_bobaloo" wrote:

I feel like I should be able to work this one out, but havn't been able to.
I know I can add item to a combo box useing .additem, but I can't figure out
how to link the combo box to a cell range ie A1:A10.

I have been trying to figure it out using vb help and looking at other posts
but have not had much success.

not sure if I am on the right track, but I have been fidling with
.rowsourcce and .controlsource.

any help is greatly appreciated

Melissa