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