Auto checkbox filling

[red1234]

Hi all,

I am trying to create a macro that will check all the check boxes in a group based on a master checkbox. What I find it difficult is to only check the check boxes in the group.

For example when the mastercheckbox 1 is check then all the check boxes in that specific range in this case(D8:D10) should be checked. Same logic for mastercheckbox 2.

I have attached the file with the example.

Thanks,
R

[harrisonland]

Hi there. Unfortunately, I can't see the code that is meant to run when you check those "masters". It's linking to a SS on sharepoint...

Also, you've got multiple overlapping checkboxes - it's going to confuse things massively if you've not done that on purpose. There are 14 checkboxes on your worksheet, but only 8 visible to the user.

Anyway...
Your checkboxes are MS form controls. While some would say steer clear from ActiveX controls, I've never had any problems with them and I find them easier to work with.

If you want to stick with form controls, you'll have to identify which checkboxes you really want to amend and run a macro that changes them. This code is in a standard module:

Please Login or Register  to view this content.

If you decide to go with ActiveX controls, something like this (this is in the "Sheet1" code):

Please Login or Register  to view this content.

I'm sure others will be able to elaborate on the pros and cons of either.

HTH
Tim

[red1234]

Thanks a lot!