Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link check boxes in multiple cells
I have a workbook with 5 worksheets. Each worksheet has check boxes (using
format toolbar) in the same cells. If one check box in the same cell is checked on the first 4 worksheets, I want the corresponding checkbox on worksheet 5 to be checked automatically. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
link check boxes in multiple cells
You can do what you ask by linking both check boxes to the sames cell. Right
click the check box and select Format Control... On the Control Tab select a cell (Sheet1 A1 for example). Do this for both check boxes. Your controls are now linked by the common cell. -- HTH... Jim Thomlinson "Taz22i" wrote: I have a workbook with 5 worksheets. Each worksheet has check boxes (using format toolbar) in the same cells. If one check box in the same cell is checked on the first 4 worksheets, I want the corresponding checkbox on worksheet 5 to be checked automatically. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link to check boxes | Excel Discussion (Misc queries) | |||
I need to link check boxes to 3 different cells | Excel Worksheet Functions | |||
How do you link Check Boxes? | Excel Discussion (Misc queries) | |||
Preventing multiple check boxes from being checked | Excel Discussion (Misc queries) | |||
how to incert multiple check boxes in excel | Excel Worksheet Functions |