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

avatar
  Subscribe  
Notify of