Microsoft Excel - Select All Checkbox (Creating a Missing Feature)
** SO SORRY for the echo in the audio. It was a video glitch that couldn't be corrected after uploading. **
Learn how to create a "Select All" checkbox using Excel's newly released Checkbox feature. This allows for bulk selection/deselection while retaining individual item selection/deselection.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
Vides for creating and controlling the new Excel Checkbox Feature:
Microsoft Excel - New & Modern Checkboxes
• Microsoft Excel - NEW & Modern Checkboxes
Microsoft Excel - Reverse Checkboxes (A different use for the upcoming Modern Checkbox feature)
• Microsoft Excel - Reverse Checkboxes (A di...
00:19 Demonstrating the "Select All" Feature
01:01 Adding Checkboxes with Basic Functionality
01:19 Setting the "Deselected" Color
01:39 Links for Earlier Checkbox Videos
02:17 Opening the Visual Basic Editor
02:54 Adding the Code to the Worksheet's Code Sheet
03:00 Overview of the Added Code
03:48 Preventing an Endless Loop Crash
04:47 Setting the Color for Checked Boxes
06:05 File Type Save Reminder
06:19 Project Conclusion