Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking more then one cell to a Check Box
I would like to link more then one cell to a check box. Each cell would do a
different function but I would like it to happen at the same time when I check the box. Is this possible to do? If not how could I make that happen then? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking more then one cell to a Check Box
The linked cell will be either TRUE or FALSE based on the state of the
checkbox. Link any cell to the checkbox, then refer to that cell from as many other cells as you want. For example, if A1 was linked to the checkbox, other cells could refer to A1: =IF($A$1,B1*10,C1/10) Hope this helps, Hutch "Jeb" wrote: I would like to link more then one cell to a check box. Each cell would do a different function but I would like it to happen at the same time when I check the box. Is this possible to do? If not how could I make that happen then? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Check Boxes | Excel Discussion (Misc queries) | |||
Cannot check the check mark box in cell | Excel Worksheet Functions | |||
Check box formulaes and linking. | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Linking check boxes so if one is true the other shows false | Excel Discussion (Misc queries) |