Selection of Option Buttons makes a list of Check Box visible and Customizing checkboxes

%3CLINGO-SUB%20id%3D%22lingo-sub-2266427%22%20slang%3D%22en-US%22%3ESelection%20of%20Option%20Buttons%20makes%20a%20list%20of%20Check%20Box%20visible%20and%20Customizing%20checkboxes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2266427%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%203%20option%20buttons%2C%20when%20I%20select%20each%20option%20button%2C%20I%20wanted%20to%20have%20a%20list%20of%20checkboxes%20to%20show.%20For%20example%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20select%20Option%20Button%201%20it%20should%20show%20a%20list%20of%20the%20following%20checkboxes%3A%20Check%20box%201%2C%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20box%202%2C%26nbsp%3BCheck%20box%203%20and%20Check%20box%204.%20Then%20if%20I%20select%20Check%20box%204%20it%20should%20automatically%20select%20the%20other%20checkboxes%20(Check%20box%201%2C%26nbsp%3BCheck%20box%202%20and%20Check%20box%203)%20and%20I%20should%20be%20also%20able%20to%20select%20or%20deselect%20them%20individually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20select%20Option%20Button%202%20it%20should%20show%20a%20list%20of%20the%26nbsp%3Bfollowing%20checkboxes%3A%20Check%20box%201%2C%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20box%202%2C%26nbsp%3BCheck%20box%203%2C%20Check%20box%205%2C%20Check%20box%206%2C%20Check%20box%207%20and%26nbsp%3BCheck%20box%208.%20Then%20if%20I%20select%20Check%20box%205%20it%20should%20automatically%20select%20the%20other%20checkboxes%20(Check%20box%201%2C%26nbsp%3BCheck%20box%202%20and%20Check%20box%203)%26nbsp%3Band%20I%20should%20be%20also%20able%20to%20select%20or%20deselect%20them%20individually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20select%20Option%20Button%203%20it%20should%20show%20a%20list%20of%20the%26nbsp%3Bfollowing%20checkboxes%3A%20Check%20box%201%2C%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20box%202%2C%26nbsp%3BCheck%20box%203%20and%26nbsp%3BCheck%20box%209.%26nbsp%3Bif%20I%20select%20Check%20box%209%20it%20should%20automatically%20select%20the%20other%20checkboxes%20(Check%20box%201%2C%26nbsp%3BCheck%20box%202%20and%20Check%20box%203)%20and%20I%20should%20be%20also%20able%20to%20select%20or%20deselect%20them%20individually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20these%20options%20buttons%20are%20not%20selected%20the%20list%20of%20these%20checkboxes%20shouldn't%20be%20visibile%20and%20all%20these%20checkboxes%20when%20they%20show%20upon%20option%20button%20selection%20they%20should%20be%20visible%20in%20one%20single%20cell%20only%2C%20no%20matter%20which%20option%20button%20is%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20My%20option%20buttons%20and%20check%20boxes%20are%20Form%20Controls.%3C%2FP%3E%3CP%3EApart%20from%20the%20above%20the%20checkboxes%20I%20have%20additional%20checkboxes%20which%20I%20dont%20want%20to%20alter%20anything.%3C%2FP%3E%3CP%3EI%20am%20using%20Office%20365%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHoping%20someone%20can%20help%20me%20out%20on%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2266427%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I have 3 option buttons, when I select each option button, I wanted to have a list of checkboxes to show. For example,

 

When I select Option Button 1 it should show a list of the following checkboxes: Check box 1, 

Check box 2, Check box 3 and Check box 4. Then if I select Check box 4 it should automatically select the other checkboxes (Check box 1, Check box 2 and Check box 3) and I should be also able to select or deselect them individually.

 

When I select Option Button 2 it should show a list of the following checkboxes: Check box 1, 

Check box 2, Check box 3, Check box 5, Check box 6, Check box 7 and Check box 8. Then if I select Check box 5 it should automatically select the other checkboxes (Check box 1, Check box 2 and Check box 3) and I should be also able to select or deselect them individually.

 

When I select Option Button 3 it should show a list of the following checkboxes: Check box 1, 

Check box 2, Check box 3 and Check box 9. if I select Check box 9 it should automatically select the other checkboxes (Check box 1, Check box 2 and Check box 3) and I should be also able to select or deselect them individually.

 

When these options buttons are not selected the list of these checkboxes shouldn't be visibile and all these checkboxes when they show upon option button selection they should be visible in one single cell only, no matter which option button is selected.

 

Note: My option buttons and check boxes are Form Controls.

Apart from the above the checkboxes I have additional checkboxes which I dont want to alter anything.

I am using Office 365 Excel.

 

Hoping someone can help me out on this.

0 Replies