Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Boxes Not Changing Independently
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Boxes Not Changing Independently
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 "Phil Hageman" wrote in message ... 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, Phil |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Boxes Not Changing Independently
Thanks, Tom. The obvious never occurred to me...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Changing data links turns combo boxes into images | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
List boxes/combo boxes | Excel Programming |