Sub Uncheckboxes()
Dim wks As Worksheet
Dim ckbx As OLEObject
Set wks = Worksheets("background")
With wks
.CheckBoxes.Value = False 'Form type clear
For Each ckbx In wks.OLEObjects
ckbx.Object.Value = False 'ActiveX type clear
Next ckbx
End With
End Sub

"Jenny B." wrote:

Good Afternoon,

I working on an Excel Sheet that Im setting up as a Test. I have set-up
Checkboxes using the Tools/Forms option that Im 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 Ive 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.