REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

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.
Private Sub CheckBox1_Click()

End Sub

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

    1. Add the following statements to the above code.
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
    1. Go to Worksheet Sheet5 (Worksheet Name) and click the check box (Design Mode should be turned OFF).
    2. Now, you can see the result in Range(“E2”) on Sheet5.

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 …

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Last Updated: March 2, 2023

4 Comments

  1. HANG Sokha December 20, 2016 at 12:54 PM

    Hello, I have problem with unsave the checkbox control. I try following steps above. It shows correctly during open, but it will not appear again after close and open again.

  2. Eric February 28, 2017 at 10:49 PM

    Hello, Thank you for the tutorial. I am new to VBA and have a question on how to code the checkboxes I’m working on. I have sheet 1 with checkboxes on it and on sheet 2 I have a list of sentences in different cells. what I want to happen is when a checkbox is checked on sheet 1 I want it to take a specific sentence from sheet 2 and put it in a “Notes” box on sheet 1. That way I can compile notes with a couple checks of some checkboxes. Any help would be greatly appreciated. Thanks

  3. Sanja October 10, 2017 at 3:37 PM

    Thank you! Saved my life!

  4. Amalor December 16, 2020 at 1:50 AM

    Hello ,

    Have a quick question. Is it necessary to link the active x checkboxes to a cell always and if yes why?

Leave A Comment