Formula using Check Boxes

[Beh162]

So I have a few formula's that are based on checkboxes that I've set up

I was wondering if it's possible to have a formula that will physically check other boxes to true. I'll write it out in terms of how I'm wanting it:

IF A10 is true (checked) then A1:A8 should all be checked.

Basically A10 is the final check box and I was hoping I can make a verification that if A10 is checked then everything else is checked. I just don't want a week to be missed

 

[James006]

Hello,

As long as your checkboxes have a linked cell ... you can use the values shown in the linked cells ...

HTH

 

[Beh162]

Hello,

As long as your checkboxes have a linked cell ... you can use the values shown in the linked cells ...

HTH

Looks like they are just check boxes, which we basically check when the data is finalized. Wasn't sure if there was a formula to set them all to true

 

[James006]

In fact, you should explore a bit ... since there are two types of checkboxes ...

In the main menu ... Developer > Design Mode will allow to determine if you are using Form or ActiveX Controls ...

In both cases, linked cells are available ... and would solve your problem ...

HTH