Check Box influencing other Check Boxes
 

Add this code to the userform module:

Private Sub CheckBox6_Click()
Dim i As Integer

If CheckBox6.Value = True Then
For i = 1 To 5
Me.Controls("CheckBox" & i).Value = True
Next i
End If
End Sub

Cheers,
Dave.
-----Original Message-----
Using Excel 97...

I have 6 checkboxes on a UserForm. 5 of them can be
individually checked but by checking CheckBox6 I would
like the other 5 checkboxes to be automatically "checked"
as well.

Does anyone know how to do this?
.