Linking 2 or 3 Combo Boxes With Each Other

Dear Guys,

I have 3 different sheets in which I have 2 common combo boxes. I want that when I change one combo on sheet1 for example then other combo on sheet2 automatically fill with same value.

Sheet1.Combo1 - > changes -> Sheet2.Combo1 (fill with the same value)

Thanks in advance,

Asghar

Hi asgharhussaini,

1. If these are 'Active X' Comboboxes, then:
a. Go into Design Mode
b. Right Click on a ComboBox. Select Properties.
c. Set the 'LinkedCell' Property to a cell e.g. 'Sheet2!A1' (no single quotes)
d. Go to a different Sheet
e. Right Click on a ComboBox. Select Properties.
f. Set the 'LinkedCell' Property to the same Sheet and Cell selected in c. above.
NOTE: If you want the cell value to be hidden, select a cell under one of the ComboBoxes.

2. If these are 'Forms' ComboBoxes then:
a. Right Click on a ComboBox.
b. Select Format Control > Cell Link and select a cell such as 'Sheet2!A1'
c. Go to a different Sheet
d. Right Click on a ComboBox.
e. Repeat Step b. above

Lewis