Add CheckBox on Worksheet or UserForm in Excel

Home/Excel VBA/Add CheckBox on Worksheet or UserForm in Excel

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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


In this Topic:

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. Click on the Worksheet location where you want to place the check box.
  4. 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.
  5. To specify the CheckBox control properties, right click on the control, and then click properties.
  6. Now, the properties dialog box will appear. You can change or specify the properties according to your wish.
  7. After adding check box on the worksheet it will be appear like below.

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. 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. 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.
    5. To specify the Check Box control properties, right click on the control, and then click properties.
    6. Now, the properties dialog box will appear. You can change or specify the properties according to your requirement.
    LIMITED TIME OFFER
By |April 12th, 2015|Excel VBA|2 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

2 Comments

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

    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 - Reply

    nice tutorial

Leave A Comment


Related pages


excel formula to find color of cellhow to write an excel macrooffset excel formulaunprotect sheet excel 2013project cost estimate template spreadsheetexcel vba colorindexexcel vba show progress bardelete row in excel vbasort formula excelddl and dml statements in sqlsample xlsm file downloadexcel macro column widthunprotect excel 2010 without passwordexcel vba hyperlink text to displayhow to avoid duplicates in excelworksheet protection excelvba quick referenceremove empty cells in excelmerging 2 columns in excelexcel formulas explainedvlookup excel column index numberexcel vba delete entire rowhow do i sort alphabetically in excelexcel vba and macrosmicrosoft excel how to merge cellsaccess vba find record in tablehow to subtract two dates in excelexcel macros basicscheckbox tutorialadvanced filter in excelvb6 check if file existshow to remove the hyperlink in excelvbscript in excelexcel macro to open a file3d chart in excelminutes template excelexcel pie chart templatehow to unlock formulas in excelhow to insert hyperlinks in excelvba variant arrayms excel developerbasic vba in excelvlookup returns namicrosoft excel vba programming for the absolute beginnerdelete empty cells in excelsample macro programs in excelclear combobox vbabeginners sqlunhide excel worksheetbuilding an excel dashboardexcel 2003 to 2013 converterusing advanced filter in excelmacro to delete duplicate rowsopen excel file vbaexcel vba with rangeexcel vba subvbs messageboxvb calculator codecell vba excelxml to excel converterfind duplicates excel 2010transpose vbaword 2013 developer tabvba excel select caseiferror vlookup excelopen dialog box vbaexcel password breaker macroconcatinate in exceldo while loop in vbaexcel advanced filter date rangevba isblankexcel vba data entry formnaming a range in excelhow to convert xls to xmlwhat are ddl statementshow to delete empty rows in excelvba write fileusing concatenate in excelvba code to save workbook