checkboxes

A

ashli

I have a group of checkboxes. I would like to have the option of
clicking one that would select all of the others. Is this possible?
Thanks.
 
L

Lynn Trapp

Add something like this to the click event of the one checkbox:

Private Sub CheckBox1_Click()
Me.CheckBox2 = True
Me.CheckBox3 = True
Me.CheckBox4 = True
End Sub

If you want all the checkboxes to mirror the first one, then you can do
this:

Private Sub CheckBox1_Click()
Me.CheckBox2 = Me.CheckBox1
Me.CheckBox3 = Me.CheckBox1
Me.CheckBox4 = Me.CheckBox1
End Sub
 
Top