CheckBox Control is used to specify or indicate binary choice. That is either Turn on or off a value. When we use more checkboxs, you can select more than one CheckBox at a time on the Worksheet. You can select multiple check boxes in a group box. Please find more details about ActiveX CheckBox Control in the following chapter.

VBA CheckBox Excel ActiveX Control Object

VBA ActiveX CheckBox Control on the Worksheet

Please find the below instructions about VBA ActiveX CheckBox Control on the Worksheet.

  1. Go To Developer Tab and then click Insert from the Controls
  2. Click on the Check box from the Activex Controls group.
  3. Drag a checkbox on the Worksheet.
  4. Right click the Checkbox (Design Mode should be turned ON).
  5. Click on View Code from the available list.
  6. Now, it takes to you VBA Editor window with the following code.
  7. Private Sub CheckBox1_Click()
    End Sub
    

    Note: In the above code ‘CheckBox1’ is the Check box name.

  8. Add the following statements to the above code.
  9. Private Sub CheckBox1_Click()
    If CheckBox1.Value = True Then
    Sheet5.Range("E2").Value = 1 ‘Check
    Else
    Sheet5.Range("E2").Value = 0 ‘UnCheck
    End If
    End Sub
    
  10. Go to Worksheet Sheet5 (Worksheet Name) and click the check box (Design Mode should be turned OFF).
  11. Now, you can see the result in Range(“E2”) on Sheet5.
  12. AxtiveX Checkbox Control

More details about Check box control

Here is the link more about how to add check box control on the Worksheet or UserForm in Excel.
Read More …

Here is the one more link to more about how to add check box control on the Worksheet or UserForm using VBA in Excel.
Read More …

Here is the one more link to more about how to remove check box control on the Worksheet or UserForm in Excel.
Read More …

Hey! Join Our Community

Get Quick Responses & Experts' Answers in Minutes!
Get Notified - When Answered Your Question!