This code works for correctly CHECKING all checkboxes within a certain frame (Frame1). But I cannot figure out how to make all the checkboxes change to UNCHECKED when the main checkbox ('chkCheckALL') is unchecked...(?)
Here is the code for checking all checkboxes within Frame1. (I just need it now to UNcheck all checkboxes when chkCheckALL is unchecked. thanks)
Here is the code for checking all checkboxes within Frame1. (I just need it now to UNcheck all checkboxes when chkCheckALL is unchecked. thanks)
VBA Code:
Private Sub chkCheckALL_Click()
Frame1.chkCheckALL.value = True
Dim Ctrl As Control
For Each Ctrl In Frame1.Controls
If TypeOf Ctrl Is MSForms.CheckBox Then
Ctrl.value = True
End If
Next
End Sub