Linking more then one cell to a Check Box

  • Thread starter Thread starter Jeb
  • Start date Start date
J

Jeb

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
 
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
 
Back
Top