dimanche 14 juin 2020

Unable to change Checkbox Form Controls in a group

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