Simple Checkbox Control in Excel

Download Project Files
Author: | Edits: don

Add a checkbox control to your worksheet and access its value using regular formulas.

This allows you to control any number of formulas, or an entire spreadsheet, from a checkbox within the worksheet.

The checkbox used here is a real checkbox, not just a value in a cell, and you can place this checkbox form control wherever you would like.

Additional Resources

Use Checkmarks in Cells in Excel

Use a Checkbox in a Worksheet in Excel (msft)

Download the Project Files

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Question? Ask it in our Excel Forum

Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Option Buttons with Formulas in Excel
Tutorial: How to make Excel option buttons in a worksheet that are linked to formulas and functions...
Custom Threshold Highlighting Trick in Excel
Tutorial: How to highlight data in Excel based on the number you input into a cell and the comparis...
Make Perfect Scrollable Boxes in Worksheets in Excel - Great for a Dashboard
Tutorial: Make a scrollable box in a worksheet in Excel that allows you to scroll through a table o...
How to Build a Simple Navigation Dashboard in Excel
Tutorial: Build a professional Navigation Dashboard in Excel that ANYONE can customize. You can add...
Sort Data With Headers in Descending Order in Excel
Macro: This Excel macro sorts data that has headers in descending order. This means that data is ...
Loop Through Controls in a UserForm
Tutorial: How to loop through all controls in a UserForm; this allows you to do things like get valu...
Tutorial Details
Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course