Range("E1").Value = ComboBox1.ListIndex + 1

--
Ian
--
"tmjhiphopcom" wrote in message
...
hello,

i made a combo box and want the next cell to change numbers when i go
thorugh the list. i do not know how to make the cell have numbers when i
shift throught the combo box list. for example, if egg was the first, i
want
the next cell to change to number 1 and so on.