A check box is a field which can be checked to store information. To create a check box in Excel VBA, execute the following steps.
1. On the Developer tab, click Insert.
2. In the ActiveX Controls group, click Check Box.
3. Drag a check box on your worksheet.
4. Right click the check box (make sure Design Mode is selected).
5. Click View Code.
Note: you can change the caption and name of a control by right clicking on the control (make sure Design Mode is selected) and then clicking on Properties. Change the caption of the check box to MyCheckBox. For now, we will leave CheckBox1 as the name of the check box.
6. Add the following code lines:
If CheckBox1.Value = True Then Range(“D2”).Value = 1
If CheckBox1.Value = False Then Range(“D2”).Value = 0
7. Click the check box on the sheet (make sure Design Mode is deselected).
Although in some situations it can be useful to directly place a check box on your worksheet, a check box is particularly useful when placed on a Userform..