Checkboxes - How to check/uncheck other checkboxes based on another checkbox

I don't have much experience/knowledge of macros, but I'm sure there's got to one out there that can do what I have in mind. Workbook with example is attached.

I have 3 main scenarios that a customer could choose. Based on what scenario they choose, there are certain products that come automatically with that scenario.

I would like someone to be able to:
1. (COMPLETE) Check a box to select which scenario they want (I have checkboxes already set up in Row 2 that do this part)
2. Once a scenario is selected, the other 2 scenarios cannot be selected at the same time (i.e. only scenario 1, 2, OR 3 can be checked, you can't check scenario 1 AND 2...)
3. Once a scenario is selected, the appropriate product checkboxes automatically check and product checkboxes for the other scenarios get unchecked (i.e. if I chose scenario 1, the appropriate products under scenario 1 would get checked but all products under scenarios 2 and 3 would get unchecked)
4. Keep the ability to check and uncheck manually (i.e. certain products come standard with scenario 1, but you have the option to check/uncheck a product to add/remove it ad-hoc)

The way the spreadsheet is set up now shows which products should be included in each scenario. I just can't get the macro to automate what I laid out above.

Thank you so much!!

Awesome - thanks. I replaced the checkboxes for Scenario 1, 2, and 3 with option buttons, which solves for my #2 requirement. Still looking for some assistance on #3 and #4:

3. Once a scenario is selected, the appropriate product checkboxes automatically check and product checkboxes for the other scenarios get unchecked (i.e. if I chose scenario 1, the appropriate products under scenario 1 would get checked but all products under scenarios 2 and 3 would get unchecked)
4. Keep the ability to check and uncheck manually (i.e. certain products come standard with scenario 1, but you have the option to check/uncheck a product to add/remove it ad-hoc)

Thank you!!

Hey jaslake -

Thanks so much! So this mostly gets what I'm looking for, except I don't want all of the checkboxes checked under scenario 1 and scenario 2...is there a way to modify that macro so that for each scenario, it only checks certain checkboxes, not all checkboxes?

Thanks!

I think in my example spreadsheet I have 13 products that can be checked for each scenario. Say if Scenario 1 is chosen, I only want 7 of those products chosen/checked automatically; then if Scenario 2 is chosen, maybe I want 10 of those 13 products checked automatically; and if Scenario 3 is chosen then I'd want all checked.

Reattached spreadsheet - so the options highlighted in yellow would be the checkboxes I want checked if that Scenario is chosen.

Yep, the spreadsheet as it sits now is how it will always be setup.

11 wouod be correct...whatever is highlighted is the corrext one! Thanks!!

Originally Posted by jaslake

Hi brooklyn_87

Your Scenario 2 appears to have eleven (11) yellow Checkboxes highlighted...which is correct...10 or 11?

Thank you both! I think this gets what I was looking for!