G
Guest
Good Afternoon,
I working on an Excel Sheet that I’m setting up as a Test. I have set-up
Checkboxes using the Tools/Forms option that I’m linking to corresponding
cells (the cells reflect a True or False value dependant on if they are
checked or not).
I found a formula which I’ve pasted below that will Clear all the check
boxes and works great, but I also need a formula that will set up a Data
Validation/ Constraint for each group of questions. Since I cannot use the
typical Data Validation because no one is actually clicking the cells itself
– is there a way to monitor just the checkboxes themselves? For example, I
have a group of 5 checkboxes in Cells B15, B16, B17, F15 and F16 which all
have different answers to a related question. What I need is a way to make
sure the User does NOT check 2 Boxes.
Any ideas would be greatly appreciated and thank you in advance for your
thoughts – Jenny B.
I working on an Excel Sheet that I’m setting up as a Test. I have set-up
Checkboxes using the Tools/Forms option that I’m linking to corresponding
cells (the cells reflect a True or False value dependant on if they are
checked or not).
I found a formula which I’ve pasted below that will Clear all the check
boxes and works great, but I also need a formula that will set up a Data
Validation/ Constraint for each group of questions. Since I cannot use the
typical Data Validation because no one is actually clicking the cells itself
– is there a way to monitor just the checkboxes themselves? For example, I
have a group of 5 checkboxes in Cells B15, B16, B17, F15 and F16 which all
have different answers to a related question. What I need is a way to make
sure the User does NOT check 2 Boxes.
Any ideas would be greatly appreciated and thank you in advance for your
thoughts – Jenny B.