Master/Slave checkboxes

Hi,

I am looking for some help setting up groups of master/slave checkboxes on a worksheet.

I would like the Master checkbox to control the checked/unchecked state of the slave checkboxes. If the master checkbox is unchecked, then the slave checkboxes should be able to be checked/unchecked independently.

I have five master checkboxes named Master1, Master2, Master3, etc.

The slave checkboxes follow the naming convention Master1_Child1, Master1_Child2, Master2_Child1, Master2_Child2, etc.

There are 3 slave checkboxes that I want to associate with the Master1 checkbox, 5 checkboxes for Master2, 4 for Master3, 15 for Master4 and 23 for Master5.

Can anyone help with the necessary code?

Thanks!

Hi ko6ux and welcome to ExcelForum,

Excellent question. You didn't specify what type of CheckBoxes, so I am assuming the CheckBoxes are 'Active X' CheckBoxes on the WorkSheet. If your CheckBoxes are 'Forms CheckBoxes', then the code will have to be modified. If you need more information about the difference, see the following thread: http://www.excelforum.com/excel-prog...ml#post3880991

See the attached sample file, which uses one ClassEvent to handle all CheckBox clicks (Thank you Andy Pope). When the Master CheckBox is On, I had no way to determine the state of the other CheckBoxes. I added a Subordinate Master CheckBox for each Master CheckBox that determines the On/Off State of the other CheckBoxes.

'ThisWorkBook' Module Code (for initialization):

Please Login or Register  to view this content.

Class Module 'ClassCheckBoxEvent' code:

Please Login or Register  to view this content.

Ordinary Code module code 'ModCheckBoxes':

Please Login or Register  to view this content.

Lewis

I see said the blind carpenter as he picked up his hammer and saw. My original post made things a lot more complicated than they should have been. The 'Subordinate Master CheckBox' scheme that i dreamed up works, but is completely unnecessary. See the attached workbook and the complete code that follows.

Lewis


'ThisWorkBook' Module Code (for initialization):

Please Login or Register  to view this content.

Class Module 'ClassCheckBoxEvent' code:

Please Login or Register  to view this content.

Ordinary Code module code 'ModCheckBoxes':

Please Login or Register  to view this content.