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 |
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 |
All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com