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

Add CheckBox on Worksheet or UserForm is using checkbox control and is used to specify or indicate binary choice. In this section we will see how to add single checkbox or multiple checkboxes on the worksheet or userform. Please find more details about add checkbox control in the following chapter.

In this Topic:

add checkbox on worksheet or userform

How to add CheckBox on the Worksheet

Please find the following instructions to add a CheckBox on the Worksheet.

  1. Click on Developer Tab on the Excel Worksheet.
  2. On the Controls group, Click Insert, and then under ActiveX controls, click Check Box button. Please find the below screenshot for the same.
  3. Excel VBA ActiveX CheckBox

  4. Click on the Worksheet location where you want to place the check box.
  5. To edit the Check Box control, click on the design mode from the Controls group on the developer tab. Please find the below screenshot for the same.
  6. Excel VBA Check Box Design Mode

  7. To specify the CheckBox control properties, right click on the control, and then click properties.
  8. Now, the properties dialog box will appear. You can change or specify the properties according to your wish.
  9. After adding check box on the worksheet it will be appear like below.
  10. Excel VBA Add CheckBox

How to add multiple CheckBoxs on the Worksheet: Using Fill Handle

  1. Follow the above instructions to add a single checkbox on the Worksheet cell.
  2. Right click on the Check Box button, and then click on Properties.
  3. Remove or delete the name of the Checkbox(Default Name like CheckCox1…). That means Caption should be empty.
  4. Now, select the check box. And then drag the fill handle over the range of cells that you want to fill.
  5. After adding multiple check box’s on the worksheet it looks like below.
  6. Excel VBA Add Multiple CheckBox

    how to add CheckBox on the UserForm

    Please find the following instructions to add a CheckBox on the UserForm.

    1. Click on Developer Tab on the Excel Worksheet.
    2. Click Visual Basic from the Code group. Go to Insert menu, click on UserForm.
    3. Now, it will display UserForm on the VBA Editor window. Default name of the User Form is UserForm 1. Please find the screen shot for the same for better understand.
    4. Excel VBA UserForm CheckBox

    5. Click on Toolbox from the menu, select the check box and then drag and drop on the userform. It will be appear in the following way. Please find screen shot for the same.
    6. Excel VBA Add CheckBox UserForm

    7. To specify the Check Box control properties, right click on the control, and then click properties.
    8. Now, the properties dialog box will appear. You can change or specify the properties according to your requirement.
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
Categories: Excel VBATags: , Last Updated: June 17, 2022

2 Comments

  1. Jim Champaigne April 18, 2016 at 8:13 PM

    Valli,
    Thank you for presenting this wonderful resource.
    I am new to VBA after spending 30 years developing in Visual FoxPro.
    This is very helpful. Looking forward to receiving your email updates.

  2. yaseenmuhammad July 9, 2017 at 10:33 AM

    nice tutorial

Leave A Comment