Simple Checkbox Control in Excel

Add to Favorites
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)


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

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...
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...
Link Worksheet Form Controls with Cells on Protected Worksheets without VBA Macros in Excel
Tutorial: Simple method to use Excel Form Controls and ActiveX Controls and link them to cells on p...
Group Data Together for Increased Readability in Excel
Tutorial: How to group data together or collapse it in order to focus only on the important data in...
Run a Macro when a User Does Something in the Workbook in Excel
Tutorial: How to run a macro when a user does something within the Workbook in Excel, such as openi...
Tutorial Details
Downloadable Files: Excel File
Similar Content
Option Buttons with Formulas in Excel
Tutorial: How to make Excel option buttons in a worksheet that are linked to formulas and functions...
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...
Excel Forum