excel 97: linking 2 combo boxes

  • Thread starter Thread starter JMCN
  • Start date Start date
J

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
 
Back
Top