Using Check boxes in Excel
The following tutorial will show you how to use Check boxes in Excel. You can use check boxes are ways of displaying text or figures that can be used in multiple formulas. In the example below, I have created a simple Shipping Log which indicates with a particular part number has been “Loaded” or still remains “Unloaded.”
First, please refer to the previous tutorial on creating Check boxes in Excel.
Next, Right click on the Check Box and select “Format Control”
In the Format Control window, you need to assign which cell will be selected for both the unchecked and checked status. In my example, I selected $D$4.
Now, if you select the checkbox, it will display “True” in cell D4. If unchecked, it will display “False”
To use the inputs in a formulation, you have to use the “True” result as the input. In my example, I used a simple “IF Statement” to demonstrate how to indicate whether a particular part has been loaded to a truck.