Remove CheckBox on Worksheet or UserForm in Excel

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

We can remove or delete checkbox on the worksheet or userform using ‘Go To Special’ or ‘Select Objects’ or by turning on Design Mode in Developer tab. when we don’t want to place checkbox control on the worksheet or userform we removes from there. Please find the more details and screenshots for clear understanding about remove 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:

Remove a CheckBox on the Worksheet: Using Go To Special

Please find the below example code, it will show you how to remove a checkbox on the worksheet using Go To Special from Editing. Go To Special command is used to sleet many types of control, one of those is objects. Please follow the below instructions to remove checkbox.

  1. Go To Home tab, click Find & Select (Editing). Now the following dialog box will be appeared. It is shown in the following screenshot.
  2. Choose the Objects option from the Go To Select command. And then click OK button.
  3. All of the check boxes have been selected. (If Worksheet contains any other objects, it will delete other objects als).
  4. Press the Delete key to delete check boxes on the keyboard.
  5. Once you click on the Delete button, all of the checkboxes will be deleted,

Remove a CheckBox on the Worksheet: Using Select Objects

Please find the below example code, it will show you how to remove a checkbox on the worksheet using Select Objects from Editing.

  1. Go To Home tab, click Find & Select (Editing), click Select Objects. It is shown in the following screenshot.
  2. Now, select the checkbox objects which you wanted to delete.
  3. Press the Delete key to delete check boxes on the keyboard.
  4. Once you click on the Delete button, all of the checkboxes will be deleted,

Remove a CheckBox on the Worksheet: Using Design Mode

Please find the below example code, it will show you how to remove a checkbox on the worksheet using Design Mode from Controls.

  1. Go To Developer tab, Click Design Mode(It Should be On). It is shown in the following screenshot.
  2. Now, select the checkbox objects which you wanted to delete.
  3. Press the Delete key to delete check boxes on the keyboard.
  4. Once you click on the Delete button, all of the checkboxes will be deleted,

More about Checkbox control

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

LIMITED TIME OFFER
By |April 15th, 2015|Excel VBA|4 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.

4 Comments

  1. jazz June 20, 2016 at 6:54 PM - Reply

    you are a life saver lol

  2. Vishvendar December 19, 2016 at 9:45 PM - Reply

    oh man… can’t thank you enough…. was trying to delete a checkbox since 1 hour as developer mode solution wasn’t working…’select object’ solution was a huge relief

  3. Howard February 10, 2017 at 3:27 AM - Reply

    Worked fine, thanks.

  4. CathyD July 28, 2017 at 5:24 PM - Reply

    Wow – very clear, THANK YOU!

Leave A Comment


Related pages


excel password protect sheetcreate pie chart in excel 2007insert comment excel shortcuthorizontal lookup in excelsql ddl dmlvba removetexfilemeeting minutes template excel formatvalue excel vbaexcel vba scriptvba combobox multiple columnswhat is ddl and dml in sqldisplay vbaexcel 2007 remove duplicatespassword protecting excel spreadsheetsunique rows in excelvba excel case statementdml downloadvba rows countexcel vba programming bookshow to insert a drop down box in excel 2007how to learn vlookup in excel 2010create pivot table macrovba programming for excelexcel loop through rowswhere is autofit in excel 2013dir function in vbaexcel macro undovba excel macrodebug vbaproject roadmap template exceldeveloper tool in excel 2007excel vba languageweekly gantt chart templatehow to do drop down list in excel 2007worksheet and workbookexcel function offsetdelete duplicate datainputbox excel vbavba copy to clipboardexcel vba programvba vbcrvba function syntaxsql statements in excelsql query excel worksheetarray length in vbamicrosoft excel how to merge cellssorting formula in exceldelete module vbaexcel formulas list 2007vba worksheet copyexcel delete rangeexcel macro applicationhow to remove excel formulaconvert from excel to csvsoftware costing templatewhat is the lookup function in excelcheckbox color changeexcel vba set background colorhow to remove password protection in excel 2010save workbook vbams excel pivot table tutorialmulti select listboxhow do you remove a hyperlink in excelwhat is the use of macro in excel 2007protecting worksheets in excelexcel vba new worksheetexcel vba uppercasemsgbox vba excelexcel vba copy to clipboardautomatic row height excel