Hi,
If you right click on the combobox, you should get a menu appear.
On the Control tab, make the input range $A$1:$A$20 or whatever your range
is, enter $A$23 or$A$24 for the cell link, and change the drop down lines to
however many rows you have.

The cell link causes a number to appear in A23 (orA24) indicating the number
of the item in the list which you've chosen with the combobox.

Try again, and I'm not sure why you get a Name? error.

Come back if you need more.

Dave

url:http://www.ureader.com/msg/10297394.aspx