Dennis

When you say index number do you mean the actual index number of the
item in the combobox or the number associated with the name on the
worksheet?

If it's the first I think you would need code to get the number into a
cell.

If it's the second you should make the combobox have 2 columns, one for
the name and one for the number.

The make the bound column the one with the number and hide it.


--
Norie
------------------------------------------------------------------------
Norie's Profile: http://www.excelforum.com/member.php...o&userid=19362
View this thread: http://www.excelforum.com/showthread...hreadid=373998