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")