Thanks to all....

I had

Data!$A$14:$A$19

Now... I have

Data!Action

Where Action is the named range. Much more better and cleaner for if and when I
have a process to insert into Action I'll have new values for my referring combo
box.

TIA

JeffP.....

"Simon Lloyd " wrote in message
...
I,m not entirely sure what you want but if you have named a range you
can have a dropdown list box by using DATA, VALIDATION, then choose
allow list then in the range box type =MC!

Don't forget to highlight the range you want the listbox to work on
befroe you choose validation.

Hope this helps!

Simon


---
Message posted from http://www.ExcelForum.com/