Master & Slave Check Boxes

Hi all,

What I need is five check boxes. One will be a master. If it is checked, the other four will be checked as a result. If the master is not checked, the four slaves can be checked independently and not affect the others.
I am using the Control Toolbox, if that matters.

Thanks you in advance your your help.

Hello flmoose,

Have you considered using Option Buttons? Their default behavior is for one and only one to be set at a time.

Sincerely,
Leith Ross

Option buttons won't work, because the user needs to be able to select one or more options at a time. The master would just make it easier to select all.

Hello flmoose,

Sorry, I misread your post. Where are these check boxes to be located - on a VBA UserForm or Excel worksheet?

Sincerely,
Leith Ross

They will be located on an Excel worksheet.
Basically, if the user wants to select all the options, they can select the master box, otherwise they can check the boxes individually to get the desired comination.

Hello flmosse,

Here is the code for the Master check box.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Save the macro in your Workbook using CTRL+S


Here is the macro to control the other check boxes. Change the names in the code to match your check box names.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

Sincerely,
Leith Ross

I thought I might be able to get away with just adding a line that states if checkbox1 is false then donotchecktheseboxes, but when that didn't work I realized that your 'checktheseboxes' is a function being run by the macro, so to add that to the macro, I need to add to the function as well.
I'm guessing the integer is what tells the function to check the boxes, is that correct? If so, what integer would I set to uncheck the boxes?

Please Login or Register  to view this content.

As you can tell, I'm not a 'expert' by any means in Excel of Visual Basic.
Your help is greatly appreciated.

Hello flmoose,

A second macro is need to clear the check boxes, A call to this macro then needs to be added to the master check box event code. Here is the second macro to clear the check boxes

Please Login or Register  to view this content.

Master Checkbox Event Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross

That's it exactly! Thanks!