excel 97: linking 2 combo boxes

[JMCN]

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

 

[steve]

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