Havok,
A lot depends on where the box is and where it is from:
If it is on the sheet and from the Forms Control
Right click the box and select Format Control
Enter the cell address in the Cell Link box
It it is on the sheet or on a form and from the Control Toolbox
Right click the box and select Properties
Enter the cell address in LinkedCell box
you may want to enter it with the sheet name like Sheet1!A1
Now when you select from the box - the entry will go to the cell.
Have your lookup formula reference this cell.
--
sb
"Havok" wrote in message
...
Hmm maybe Im at a loss as to how to use the combobox to put the country
in the cell?
I am by far an Excel expert. (Im actually a chemical engineer)
Could you provide a little more step by step detail... ??
The help is very much appreciated.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/