You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions he

http://www.contextures.com/xlNames01.html

If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.


Doyle Brunson wrote:
I think I know what I am doing wrong. I am just inserting a combobox,
right clicking it and inserting the range and linked cell into the
prompt boxes.

But in fact do I need to write a macro to make this work?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html