Check/Uncheck All Checkboxes with a Single Checkbox - Excel Macro

In this video, we create a single checkbox to check, or uncheck, all the checkboxes on the sheet.

In the video, we have a checklist similar to the one created in the link below. Checking, or unchecking, each box is time-consuming and a little irritating.

Create an interactive checklist in Excel -

This video tutorial shows you how to write the macro using Excel VBA that will loop through the checkboxes on a sheet and select/deselect each one.

The VBA code can be adapted to just remove the checks or to be run from a command button instead of a checkbox.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[jim]

Thanks. If I was to have this macro only apply to a specified column what would it looking like? I've got Checkboxes in columns B, F & J and don't want to apply this to the whole sheet, just 1 column.

[mtszymon]

Thank You. My informatics-knowledge is basic - like my English, but it is Your film, show me the way to solve this problem.
The way I was looking ineffectively on sides in my own language.
Great job.

[fernandosantos]

Computergaga Man, you're topp, you help me so much, thank you from Brazil

[lenac]

I thought assigning the checkboxes to be the same value as 'Check Box 2' is really smart and simple way to handle this rather than using a For Loop to make them True/False depending on whether 'Check Box 2' is checked or unchecked. Thumbs up there! :)

[hassanadelsobh]

Thank You are the best very simple and straight to the point

[wayneedmondson]

Hi Alan.. great trick go go along with your other video on setting up a basic check box list. Simple loops in VBA can do a lot of work for us. Thumbs up!

[logandowell]

This is remarkably helpful, well done.

[kanwardeepsingharora]

Hi. How do i group only some of the checkboxes. Lets say there are 10 checkboxes on a sheet and i want a button to only check/uncheck only 5 of them together. How do we do that?

[alexanderfrancis]

Hi Alan,
Really like your Videos and are great to follow! Can you tell me how I can reduce the "check all checkboxes" down to a certain column. I would only want Column D to check all the checkboxes. thanks in advance and best regards!

[mohideenthassim]

Thank you Alan a very useful tutorial. Cheers Mohideen

[sallybarton]

Brilliant work and thank you, this is really helpful!! Do you (or any other Excel gurus out there) know if it is possible to do the same using an ActiveX Control checkbox? I couldn't work out how to do it...

[sasavienne]

An excellent tutorial... Thanks Alan. 👍 🌟 🌟 Stay safe. Kind regards. Salim

[pambospro]

Top work. Any idea how to do this for a single column?

[ismailismaili]

Wow it was awesome thank you so much Mr

[nadermounir]

Very useful video 📹 👍 can we use an event instead ?

[samanthagreen]

I need a table with tasks to be done with each day of the month at the top. I need check boxes for each task for each day can you tell me how I can do that please.
There are 23 tasks down in column B and then I need dates across the top in each column and a months worth of check boxes for each task for each day.
Your videos are very good and helpful. Thank you

[stagweekenders]

Great stuff, thanks. What would the macro be if I only wanted to deselect all checkboxes, please?

[raghidhittini]

Thank you so much it's fantastic but is there any code to select certains checkboxes not all of them?
Thanks in advance for your help

[blake]

is there a way for this to work on multiple different sheets? because it only worked on sheet 1, and i need it to work on multiple different sheets on the same file at different times

[tiannalima]

How do you get this macro to only apply to certain row and column of your sheet? For example you only want it applied to the checkboxes in C9-C20?