check boxes

  • Thread starter Thread starter arciduca79
  • Start date Start date
A

arciduca79

Good mornign everyone.
Say I have a list of checkboxes. I would like to have a "master
checkbox that, when I click on it, has all of the others clicked, too.
How do I do this? Thanks a lot,
 
Hi! arciduca79

It must script code to the "master" checkbox ' click event.

for example:

'checkbox1 control the checkbox2 and checkbox3.

Private Sub CheckBox1_Click()

If CheckBox1 = True Then

CheckBox2 = True
CheckBox3 = True
Else
CheckBox2 = False
CheckBox3 = False

End If

End Sub

LoadHigh
From China
 
Assuming your checkboxes are from the Forms toolbar, you can right-click
the "master" checkbox and attach this macro:

Public Sub MasterCheckbox()
If ActiveSheet.CheckBoxes("Master Check Box").Value = 1 Then _
ActiveSheet.CheckBoxes.Value = True
End Sub
 
Back
Top