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.

In this Topic:

remove checkbox on worksheet or userform

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. Checkbox Goto Special in Excel

  3. Choose the Objects option from the Go To Select command. And then click OK button.
  4. All of the check boxes have been selected. (If Worksheet contains any other objects, it will delete other objects als).
  5. Press the Delete key to delete check boxes on the keyboard.
  6. 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. remove Checkbox Select object

  3. Now, select the checkbox objects which you wanted to delete.
  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 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. Excel VBA CheckBox Design Mode

  3. Now, select the checkbox objects which you wanted to delete.
  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 Checkbox Controls using VBA

Here is the VBA code to remove all Checkbox controls (Worksheet Form Controls) in active sheet.

Sub sbRemoveCheckboxesinActiveSheet_FormControls()

For Each shp In ActiveSheet.Shapes
    If shp.Type = msoFormControl Then
        If shp.FormControlType = 1 Then shp.Delete
    End If
Next
    
End Sub

And below is the VBA Macro to remove all OLE Checkbox controls in active sheet.

Sub sbRemoveCheckboxesinActiveSheet_OLEControls()

For Each shp In ActiveSheet.Shapes
If shp.Type = msoOLEControlObject Then
        If shp.OLEFormat.Object.OLEType = 2 Then shp.Delete
    End If
Next    
End Sub

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 …

Premium Project Management Templates

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.

PREMIUM TEMPLATES
LIMITED TIME OFFER
ON SALE80% OFF
BROWSE ALL TEMPLATES

Advanced Project Planning Templates

Excel Templates

VIEW DETAILS

120+ Project Management Templates Pack

Excel | PowerPoint | Word

VIEW DETAILS

ULTIMATE RESOURCE MANAGEMENT TEMPLATE

Excel Template

VIEW DETAILS

50+ Essential Project Management Templates

Excel | PowerPoint | Word

VIEW DETAILS

Project Portfolio Management Templates

Excel | PowerPoint Templates

VIEW DETAILS

50+ Excel Project Management Templates

Excel Templates

VIEW DETAILS

By Published On: April 15th, 2015Categories: Excel VBATags: ,

Share This Story, Choose Your Platform!

About the Author: Valli

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.