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.

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.

What sort of combobox. If it is a controls toolbox, then link a cell to the
combo using the LinkedCell property, and then use MATCH to find its index in
the source

=MATCH(linked_cell,listfill_range,0)

If it is a forms toolbar, again set the cell link property (right-click the
combobox, select the control tab) to a cell, and that cell will capture the
index.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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.