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

Excel VBA beginners course http://bit.ly/37XSKfZ'>http://bit.ly/37XSKfZ

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

Create an interactive checklist in Excel
https://www.computergaga.com/blog/cre...

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;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ'>http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1