See if this macro does the job for you. It uses a function that
identifies whether the check box is in column A or B, and then
changes all the check box values in that column to the value
of the controlling check box.
As each check box name ends with a number, you adapt my code
to your check boxes in column A using these numbers. To do this,
edit the function and fill in your own numbers, where I have just 4 numbers
(for the 4 check boxes in column A) in this example. Include a number for
the column A controlling check box. The code assumes that any
check box not identified as being in column A is in column B.
If you decide to try this in your application, assign the first macro
ColA_ChBoxes to the controlling check box in column A, and
the second macro, ColB_CkBoxes, to the column B controlling
check box.
The example workbook is attached.
Bookmarks