excel 97: linking 2 combo boxes
 

hello

i have two combo boxes, combo1 is the input range Sheet2!$A$1:$A$8 and
the combo2 is the input range Sheet2!$B$1:$B$8. how does one link the
cells together. in other words if i select A6 value, combo2 equals B6
value etc. i have already tried the format control format tab and
then clicked on the "cell link" and highlight all of range B1:B8. but
when i select cell A1 it give me the value = 1 even though the value
in cell B1 = 1731-0332-0441.

strange but it's driving me nutty :)

thanks in advance jung

excel 97: linking 2 combo boxes
 

In the combobox1 event you could put
Combox2.ListIndex = Combobox1.ListIndex

--
sb
"JMCN" wrote in message
om...
hello

i have two combo boxes, combo1 is the input range Sheet2!$A$1:$A$8 and
the combo2 is the input range Sheet2!$B$1:$B$8. how does one link the
cells together. in other words if i select A6 value, combo2 equals B6
value etc. i have already tried the format control format tab and
then clicked on the "cell link" and highlight all of range B1:B8. but
when i select cell A1 it give me the value = 1 even though the value
in cell B1 = 1731-0332-0441.

strange but it's driving me nutty :)

thanks in advance jung