UNcheck checkboxes in frame control?

[kbishop94]

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)

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

 

[Domenic]

Try . . .

Private Sub chkCheckALL_Click()
    Dim Ctrl As Control
    For Each Ctrl In Frame1.Controls
        If TypeOf Ctrl Is MSForms.CheckBox Then
            Ctrl.Value = (Me.chkCheckALL.Value = True)
        End If
    Next
End Sub

Hope this helps!

 

[kbishop94]

Try . . .

Private Sub chkCheckALL_Click()
    Dim Ctrl As Control
    For Each Ctrl In Frame1.Controls
        If TypeOf Ctrl Is MSForms.CheckBox Then
            Ctrl.Value = (Me.chkCheckALL.Value = True)
        End If
    Next
End Sub

Hope this helps!

Yes it did, that works exactly how I needed it to. Thank you very much.

 

[Domenic]

That's great, I'm glad I could help.

Cheers!