How to Click on one Checkbox that clicks all Checkboxes VBA

Question

I want to be able to Click on one Checkbox on Excel VBA that is able to Click on 5 other Checkbox's. My scenario is I want to create a table that shows 5 types of Data, what I want to accomplish is to create a Checkbox that clicks all of these other checkbox's, and therefore loads all data without the user having to check all 5 of these other Checkbox's. I want this checkbox to also be ticked if the user has ticked all 5 other options, and when the user has clicked then unclicked this Checkbox, for all the options to unselect itself. Hope someone can help?

Sivaprasath Vadivel · Accepted Answer · 2017-03-07 10:33:39Z

1

inside the main check box click function add the oleobjects.object.value property

sub checkbox1_click()
activeworkbook.sheets(1).oleobjects("checkbox_2").object.value=true
end sub

you can add more check boxes in a similar way....so whenever the main check box (checkbox 1 ) is enabled all other checkboxes within the checkbox sub will also be enabled

answered Mar 7, 2017 at 10:33

Sivaprasath Vadivel

5415 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sivaprasath Vadivel Over a year ago

similarly you can also reverse this.... by creating a sub that checks whether the five checkboxes values are true and change the value of the main check box

Collectives™ on Stack Overflow

How to Click on one Checkbox that clicks all Checkboxes VBA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related