Remove CheckBox On Worksheet Or UserForm In Excel - Analysistabs

Home » How To Delete Checkboxes In Excel » Remove CheckBox On Worksheet Or UserForm In Excel - Analysistabs

Maybe your like

Skip to content Toggle Navigation

120+ Professional Project Management Templates!

Save Up to 85% LIMITED TIME OFFER

View DetailsAnalysistabs Search for: Go to... Home » Excel VBA » Remove CheckBox on Worksheet or UserForm in ExcelPreviousNextExcel VBARemove CheckBox on Worksheet or UserForm in Excelcheckbox, VBA|

Share This Post

remove checkbox on worksheet or userform In This Article
  • Remove a CheckBox on the Worksheet: Using Go To Special
    • Remove a CheckBox on the Worksheet: Using Select Objects
    • Remove a CheckBox on the Worksheet: Using Design Mode
    • Remove Checkbox Controls using VBA
  • Deleting Form Control Checkboxes
    • Delete Form Checkboxes In Range
    • Delete Form Checkboxes In Sheet
    • Delete Form Checkboxes In Workbook
  • Deleting ActiveX Checkboxes
    • Delete ActiveX Checkboxes In Range
    • Delete ActiveX Checkboxes In Sheet
    • Delete ActiveX Checkboxes In Workbook
    • More about Checkbox control
VBA Code Library
  • VBA Code Explorer
  • Application
    • Methods
      • Calculate
      • CalculateFull
      • FindFile
      • Goto
      • Run
      • Wait
    • Properties
      • Calculation
      • Caption
      • DisplayAlerts
      • DisplayFormulaBar
      • DisplayFullScreen
      • DisplayScrollBars
      • DisplayStatusBar
      • EnableEvents
      • Path
      • ScreenUpdating
      • StatusBar
      • UserName
      • WindowState
  • Workbook
    • Methods
      • Activate
      • Close
      • Protect
      • ProtectSharing
      • RefreshAll
      • RejectAllChanges
      • RemoveUser
      • RunAutoMacros
      • Save
      • SaveAs
      • SaveCopyAs
      • SendMail
      • Unprotect
      • UnProtectSharing
  • Worksheet
    • Methods
      • Activate
      • Calculate
      • Copy
      • Delete
      • Move
      • Protect
      • Select
      • Unprotect
  • Excel VBA Range
    • Methods
      • Activate
      • AddComment
      • AdvancedFilter
      • Calculate
      • Clear
      • ClearComments
      • ClearContents
      • ClearFormats
      • ClearHyperlinks
      • Copy
      • CopyFromRecordset
      • Cut
      • Delete
      • Excel VBA PasteSpecial
      • Find
      • Insert
      • ListNames
      • Merge
  • ActiveX Controls
    • CheckBox
      • Properties
        • Alignment
        • BackColor
        • Caption
        • Enabled
        • Height
        • Left
        • TextAlign
        • Top
        • Width
    • ComboBox
    • CommandButton
    • Image
    • Label
    • ListBox
      • Properties
        • BackColor
        • BorderStyle
        • ColumnCount
        • Enabled
        • Height
        • Left
        • MultiSelect
        • TextAlign
        • Top
        • Width
    • OptionButton
      • Caption
    • TextBox
  • Userform
    • CheckBox
    • ComboBox
    • CommandButton
    • Image
    • Label
    • ListBox
    • OptionButton
    • TextBox
    • Tutorial & Examples
  • Projects
    • Calculator using Excel VBA UserForm
    • Data Entry Userform
    • Excel VBA UserForm: Difference Between Two Dates
    • TOC creator in Excel Workbook using VBA
    • VBA List Folders Subfolders in Directory
    • VBA to Append Data from multiple Excel Worksheets into a Single Sheet – By Column
    • VBA to Consolidate data from multiple Excel Worksheets into a Single Sheet – By Row

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

View Details

120+ PROFESSIONAL

Project Management Templates

View Details
120+ PM Templates Includes:

  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Effortlessly Manage Your Projects

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

Share Post

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 a CheckBox on the Worksheet: Using Go To Special
  • Remove a CheckBox on the Worksheet: Using Select Objects
  • Remove a CheckBox on the Worksheet: Using Design Mode
  • ReDeleteFormCheckboxesInRangemove Checkbox Controls using VBA
  • Delete Form Checkboxes
    • Delete Form Checkboxes in Range
    • Delete Form Checkboxes in Sheet
    • Delete Form Checkboxes in Workbook
  • Delete ActiveX Checkboxes
    • Delete ActiveX Checkboxes in Range
    • Delete ActiveX Checkboxes in Sheet
    • Delete ActiveX Checkboxes in Workbook
  • More about Checkbox control

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.

Checkbox Goto Special in Excel

  1. Choose the Objects option from the Go To Select command. And then click OK button.
  2. All of the check boxes have been selected. (If Worksheet contains any other objects, it will delete other objects als).
  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 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.

remove Checkbox Select object

  1. Now, select the checkbox objects which you wanted to delete.
  2. Press the Delete key to delete check boxes on the keyboard.
  3. 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.

Excel VBA CheckBox Design Mode

  1. Now, select the checkbox objects which you wanted to delete.
  2. Press the Delete key to delete check boxes on the keyboard.
  3. 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. Remove Check Box in Excel

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

Deleting Form Control Checkboxes

Form Control checkboxes are straightforward interactive elements in Excel, commonly used to facilitate binary choices. They are part of Excel’s standard toolset and are favored for their simplicity and ease of use. Integrated directly into the spreadsheet without requiring external libraries, Form Control checkboxes are often used in templates, forms, and surveys. Their graphical representation is basic, and their primary functionality is to present users with an “on” or “off” selection. When designing user interfaces in Excel or gathering basic user inputs, these checkboxes serve as a go-to choice for many spreadsheet creators.

Delete Form Checkboxes In Range

Deletes Form Control checkboxes within the specified range. Ideal for fine-tuning sections of large spreadsheets without affecting the entire sheet.

Sub DeleteFormCheckboxesInRange(rng As Range) Dim shp As Shape For Each shp In rng.Worksheet.Shapes If Not Intersect(rng, shp.TopLeftCell) Is Nothing Then If shp.TopLeftCell.Address = shp.BottomRightCell.Address And _ shp.Type = msoFormControl And shp.FormControlType = xlCheckBox Then shp.Delete End If End If Next shp End Sub

Delete Form Checkboxes In Sheet

Clears all Form Control checkboxes from a given worksheet. Perfect for refreshing or resetting an entire sheet without manually searching for checkboxes.

Sub DeleteFormCheckboxesInSheet(ws As Worksheet) Dim shp As Shape For Each shp In ws.Shapes If shp.Type = msoFormControl Then If shp.FormControlType = xlCheckBox Then shp.Delete End If End If Next shp End Sub

Delete Form Checkboxes In Workbook

Comprehensively removes Form Control checkboxes across all sheets in a workbook. Streamlines the process of cleansing an entire workbook filled with these checkboxes.

Sub DeleteFormCheckboxesInWorkbook(wb As Workbook) Dim ws As Worksheet For Each ws In wb.Worksheets DeleteFormCheckboxesInSheet ws Next ws End Sub

Deleting ActiveX Checkboxes

ActiveX checkboxes provide a more advanced and flexible option for binary selections in Excel. Unlike Form Control checkboxes, ActiveX controls can be easily customized, both in appearance and functionality. Originating from the ActiveX platform, these checkboxes can execute more complex VBA scripts, react to various events, and be styled in detail. They offer an enhanced level of interactivity, making them the preferred choice for more sophisticated Excel applications. However, with this advanced capability comes a steeper learning curve, particularly for users unfamiliar with the ActiveX environment or VBA programming.

Delete ActiveX Checkboxes In Range

Targets and deletes ActiveX checkboxes within a given range. Offers precision in complex sheets by addressing only the designated section.

Sub DeleteActiveXCheckboxesInRange(rng As Range) Dim obj As Object For Each obj In rng.Worksheet.OLEObjects If obj.progID = "Forms.CheckBox.1" And _ Not Intersect(rng, obj.TopLeftCell) Is Nothing Then obj.Delete End If Next obj End Sub

Delete ActiveX Checkboxes In Sheet

Scours an entire worksheet to locate and delete all ActiveX checkboxes. Useful for ensuring a clean sheet, especially before in-depth data analysis.

Sub DeleteActiveXCheckboxesInSheet(ws As Worksheet) Dim obj As Object For Each obj In ws.OLEObjects If obj.progID = "Forms.CheckBox.1" Then obj.Delete End If Next obj End Sub

Delete ActiveX Checkboxes In Workbook

Removes every ActiveX checkbox across the entire workbook. Ideal for starting afresh and ensuring consistency across larger projects or data sets.

Sub DeleteActiveXCheckboxesInWorkbook(wb As Workbook) Dim ws As Worksheet For Each ws In wb.Worksheets DeleteActiveXCheckboxesInSheet ws Next ws 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 …

Effortlessly Manage Your Projects and Resources120+ 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
Browse All TemplatesProject Management Templates

All-in-One Pack 120+ Project Management Templates

120+ PM Templates

Essential Pack 50+ PM Templates

50+ PM Templates

Excel Pack 50+ Excel PM Templates

50+ Excel Templates

PowerPoint Pack 50+ Excel PM Templates

50+ PPT Templates

MS Word Pack 25+ Word PM Templates

25+ Word Templates
Ultimate Project Management Template
Ultimate PM Template
Ultimate Resource Management Template
Resource Management
Project Portfolio Management Templates
PPM Templates

Related Posts

VBA ActiveSheet – Excel Active Sheet Object VBA ActiveSheet – Excel Active Sheet Object Gallery

VBA ActiveSheet – Excel Active Sheet Object

August 6, 2019|0 Comments Excel VBA ColorIndex Excel VBA ColorIndex Gallery

Excel VBA ColorIndex

July 6, 2019|0 Comments Excel VBA Copy Range to Another Sheet with Formatting Excel VBA Copy Range to Another Sheet with Formatting Gallery

Excel VBA Copy Range to Another Sheet with Formatting

July 5, 2019|1 CommentPublished On: April 15, 2015Categories: Excel VBATags: checkbox, VBALast Updated: August 29, 2023

About the Author: PNRao

Hi, I’m PNRao—an Excel & VBA developer with 20 years in data mining, automation, and project management. Day-to-day I turn raw data into clear insight, replace repetitive work with one-click workflows, and guide teams with smarter project management. On Analysistabs.com I share battle-tested tips on Excel, VBA, SQL, Automation, Project Management, and Data Analysis—plus a growing library of free and premium Project Management Templates. My goal is to help you work faster, build sharper tools, and level up your career. Let's master data and manage projects effectively, together.

8 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!

  5. Jenni October 22, 2017 at 6:41 AM - Reply

    If you have a sheet with pictures and checkboxes, these instructions will delete both the checkboxes and photos. What if you want to keep the photos.

  6. PNRao October 26, 2017 at 12:49 PM - Reply

    Hi, We have added a VBA code to remove only checkboxes and keep the photos and other objects as it is.

  7. Haydn December 16, 2020 at 5:55 AM - Reply

    This worked well. Thanks so much. It was driving me insane trying to get rid of some damn check boxes on my excel sheet.

  8. Ameera March 27, 2023 at 12:15 PM - Reply

    i was struggling with this for a while and only this post helped me solve my problem! thank you so much!!

Leave A Comment Cancel reply

Comment

Save my name, email, and website in this browser for the next time I comment.

Effectively Manage Your Projects and  Resources

With Our Professional and Premium Project Management Templates!View Details

ANALYSISTABS.COM provides free and premium project management tools, templates and dashboards for effectively managing the projects and analyzing the data.

We’re a crew of professionals expertise in Excel VBA, Business Analysis, Project Management. We’re Sharing our map to Project success with innovative tools, templates, tutorials and tips.

Project Management

Excel VBA

Download Free Excel 2007, 2010, 2013, 2016, 2019 + Microsoft Office 365 Templates, Dashboards, Tools for Project Management, Data Mining, Analysis, Visualization and VBA Automation. Learn Project Management and VBA for Microsoft Excel, Word, PowerPoint, Access, Outlook to develop applications for retail, insurance, banking, finance, telecom, healthcare domains.

Analysistabs Logo

© 2023 Analysistabs | Sitemap | Your Privacy | Terms

Page load link Go to Top

Tag » How To Delete Checkboxes In Excel