Scenario:
There are six Forms checkboxes that had been "grouped" and named app_list There are other individual Forms checkboxes in the entire Worksheet
When I run this macro that I had found online:
*Sub ClearFormsCheckboxes()
Dim chBox As CheckBox
For Each chBox In ActiveSheet.CheckBoxes
If chBox.Value = 1 Then
chBox.Value = 0
End If
Next
End Sub*
...the individual checkboxes gets unchecked but the group "app_list" remains unchanged. I've been thinking of just doing an ungroup - uncheck - regroup method but that seems too much.
There has to be something I can do to change the value of the entire group.
Please help!
Aucun commentaire:
Enregistrer un commentaire