| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Check Boxes
I have a set of check boxes on one tab, and another on the next tab. Is
there anyone to link them together so if one is checked off the other ones is as well? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking Check Boxes
Assign all the check boxes to the same linked cell.
For example, make the linked cell Sheet1A10 Give this cell a defined name: InsertNameDefine: Name: LinkCell Refers to: =Sheet1!$A$10 OK Now, set the linked cell for each check box to be LinkCell Right click the check box Select Format Control Cell Link: LinkCell OK -- Biff Microsoft Excel MVP "Nightshade" wrote in message ... I have a set of check boxes on one tab, and another on the next tab. Is there anyone to link them together so if one is checked off the other ones is as well? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking Check Boxes
Perfect. Thank you
"T. Valko" wrote: Assign all the check boxes to the same linked cell. For example, make the linked cell Sheet1A10 Give this cell a defined name: InsertNameDefine: Name: LinkCell Refers to: =Sheet1!$A$10 OK Now, set the linked cell for each check box to be LinkCell Right click the check box Select Format Control Cell Link: LinkCell OK -- Biff Microsoft Excel MVP "Nightshade" wrote in message ... I have a set of check boxes on one tab, and another on the next tab. Is there anyone to link them together so if one is checked off the other ones is as well? Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking Check Boxes
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Nightshade" wrote in message ... Perfect. Thank you "T. Valko" wrote: Assign all the check boxes to the same linked cell. For example, make the linked cell Sheet1A10 Give this cell a defined name: InsertNameDefine: Name: LinkCell Refers to: =Sheet1!$A$10 OK Now, set the linked cell for each check box to be LinkCell Right click the check box Select Format Control Cell Link: LinkCell OK -- Biff Microsoft Excel MVP "Nightshade" wrote in message ... I have a set of check boxes on one tab, and another on the next tab. Is there anyone to link them together so if one is checked off the other ones is as well? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
| Linking check boxes so if one is true the other shows false | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
| Check Boxes | Excel Worksheet Functions | |||
Hybrid Mode
