I have two sets of checkboxes, set A and set B. If you hit a checkbox in set A I would like all the boxes in set B to become true, and if you hit a checkbox in set B I would like all the boxes in set A to become true.
The easiest method to do this would just be to assign a macro to each of the checkboxes in set A that says Range("R1:R85")=TRUE (set all set B checkboxes to TRUE) and a macro to each of the checkboxes in set B that says Range("M1:M85")=TRUE.
Assigning a macro like this doesn't work however, because my check boxes are pretty close together and when I assign a macro some buttons become impossible to hit as the area over them triggers nearby checkboxes instead. So my next best solution would probably be to trigger an event instead, but as far as I can tell worksheet_change event isn't triggered by hitting a checkbox.
Is there another event that is triggered when hitting a check box? or is there some other way I can accomplish my goal with or without macros?
Thanks,
~Gold Fish
The easiest method to do this would just be to assign a macro to each of the checkboxes in set A that says Range("R1:R85")=TRUE (set all set B checkboxes to TRUE) and a macro to each of the checkboxes in set B that says Range("M1:M85")=TRUE.
Assigning a macro like this doesn't work however, because my check boxes are pretty close together and when I assign a macro some buttons become impossible to hit as the area over them triggers nearby checkboxes instead. So my next best solution would probably be to trigger an event instead, but as far as I can tell worksheet_change event isn't triggered by hitting a checkbox.
Is there another event that is triggered when hitting a check box? or is there some other way I can accomplish my goal with or without macros?
Thanks,
~Gold Fish