Combo Boxes Not Changing Independently

[Guest]

A workbook has 12 worksheets with a ComboBox on each worksheet. All 12 ComboBoxes are named ComboBox1, have exactly the same properties, and were inserted form the Control Toolbox. On a worksheet named “Variables†are the locations of the LinkedCell and ListFillRange – used for all 12 ComboBoxes (done this way so I only have to make changes once when selection data changes)

The problem: when I select from the ComboBox dropdown on one worksheet, all 12 ComboBoxes change to that selection on all 12 worksheets, rather than changing independently on each worksheet

How do I make the ComboBoxes work independently on each worksheet

Thanks
Phi

 

[Tom Ogilvy]

don't use the same linked cell - if you want them to change independently,
why would all output go to a single cell?

Anyway, when one updates the linked cell that cell updates all the others
because communication between the linked cell and the comboboxes is a two
way path.

--
Regards,
Tom Ogilvy

A workbook has 12 worksheets with a ComboBox on each worksheet. All 12

ComboBoxes are named ComboBox1, have exactly the same properties, and were
inserted form the Control Toolbox. On a worksheet named "Variables" are the
locations of the LinkedCell and ListFillRange - used for all 12 ComboBoxes
(done this way so I only have to make changes once when selection data
changes).

The problem: when I select from the ComboBox dropdown on one worksheet,

all 12 ComboBoxes change to that selection on all 12 worksheets, rather than
changing independently on each worksheet.

 

[Guest]

Thanks, Tom. The obvious never occurred to me...