Linked Checkbox – True / False

Before starting this tutorial, please ensure that you are familiar with adding a checkbox into an Excel worksheet. Also, it may help to download the demonstration file.

Download the Demo File:  Check Boxes in Excel.xlsx

In this tutorial, we will cover linking a checkbox in excel with additional logic. For example, when a checkbox is clicked, a specific cell shows the value of True or False.

  • Right click on the checkbox and click “Format Control”
  • Go to the control tab.
  • Select “Checked” or “Unchecked”
  • We then select the cell we want to link.

In the following video, I show how this can used to load a shipping container.

You can also create a nice status feature using the following “IF function.

 =IF(D4,"Loaded","Unloaded") 

Leave a Reply

SUMIF Function

The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common

Read More »

VBA Select Method

Selection is a method in Excel VBA that performs an action. You use the Select method to select a single

Read More »
Scroll to Top