Select All or None of Checkboxes using Radio Button

Hello.

I'm here to request an assistance on how I can record a vb macro to perform these tasks.

The excel file is attached.

I have 5 checkboxes that I would like for them to all be checked or unchecked at the click of a single radio button on the top.

In addition, I am interested in having it select certain checkboxes only based on which group they're in.

I am such a newb with VB. I thank you for any assistance. Cheers!

ADDITIONAL INFORMATION:

In the example I've provided, I have only 5 checkboxes. In reality, I'm working with a file that has 300+ rows, each with a checkbox. As time goes on, I will need to add extra rows with new checkboxes.

Can it be programmed so that "All" check boxes react to a command, instead of pointing to a checkbox one by one?

Hello smk224,

Here are 2 of the macros you wanted. If your groups will be together then you should use a GroupBox for the check boxes. This make coding more simple. Add these macros to a module in your VBA project and then assign them to the Option Buttons.

Please Login or Register  to view this content.

Originally Posted by smk224

However, the groups are not going to be together as it'll be eventually mixed and matched like A,A,B,A,B,B,A,B for example.

Is there a macro I can use for that?

It can be done. You will just have to be able to tell us how the macro will know which checkboxes belong to A, and which ones belong to B, etc.
For example will the words "Group A - " be in every checkbox text for A?

If you can not think of a way for the macro to tell which ones belong to A, then something like this can be written.
You select all the As and run a macro that saves them all in a hidden sheet. Then a macro can be written that looks on the hidden sheet to see which ones are in Group A. And you attach that macro to your radio button.

Here's some code based on your sample workbook (revised copy attached too):

Please Login or Register  to view this content.