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.

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


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.

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 …

LIMITED TIME OFFER

2 Comments

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

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

    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

Leave A Comment


Related pages


vba code to unprotect workbookexcel 3d surfacetrim function excelms excel vlookup formulaworksheetfunction.vlookup vbarca report templateexcel vba unprotect worksheetquick keys in excelhow to find duplicates in excel 2003duplicate formula excelexcel with vba programminguserform unload vbaexcel vba division remainderunhide row in excelvbscript output to text filevba range clearconditional statements in exceltrim function in accessexcel 2013 unprotect sheetexcel protected sheet passwordexcel vba goto cellvb to access database connection codechange data source for all pivot tablesvba excel tablesort macro excelcalculator codes in visual basicexcel sumifwhat are dml commandsvba cut and pasteexcel vba userform listboxexcel macro cell valueexcel consolidate data from multiple rowsexcel vba filtermacro dialog boxhow do you sort alphabetically in excelgenerating xml from excelvlookup error refvlookup in excel formula with examplematch formula in excel 2007excel pivot table example datamicrosoft excel advanced tutorialwriting excel macrossql programmer interview questionsexcel select worksheetexcel formulas list 2007access vba case statementvb 6.0 interview questions and answers for experiencedvba user inputsql sasvba vbnewlineexplain pivot tablesfinding duplicate rows in excelexcel vba vlookupmicrosoft excel gantt chart templateproject management tracker excelexcel uppercasevlookup in excel 2007 with examplemsgbox yes no vba accessvba combobox control sourceif statement in excel macrohow to record macro in excel 2007example of ddlexamples of dashboards in excelestimate template exceleasy excel vbaado odbc connection stringexcel formulas greater thanopen excel from access vbahow to print cells in excelunshare a workbookfree estimate template wordvba for loop rangefind duplicates in excel sheet