Checkbox Macro - Multiple Checkbox

[bbworld]

Hello,

I have a workbook with 2 sheets.

Sheet 1 contains 3 rate plans all with their own checkbox (form)

1. Basic
2. Advantage
3. Gold

I have a second sheet that all the inclusions of the rate plans.

I have added on the top of the sheet the rate plans and a check box next to the inclusion under each rate plan.

I would like to have inclusions ticked on sheet 2 based on the rate plan selected in sheet 1.

For example -

If the Basic rate plan was selected then all the options identified for Basic would be ticked with all the other check boxes protect.

If however a customer wanted Gold, all the inclusions must be ticked from Basic and Advantage.

Thanks
Mike

 

[bbworld]

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1105299-form-control-checkbox-multiple-checkboxes.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.