How to Insert a Checkbox in Excel

Inserting a checkbox in Excel is an easy task. The checkbox control is available in the Excel developer tools option. Checkbox and other controls like dropdowns can be quite helpful while designing forms in Excel.

These controls prevent users from entering some unwanted data in your forms, and hence they are preferred.

In this post, we will understand how to insert a checkbox in Excel. After that, we will also see an example of how checkboxes can ease data analysis tasks.

How to Insert a Checkbox in Excel

Excel checkbox control is present in the “Developer Tools” menu item. And by default “Developer Tools” menu item is hidden in Excel. So first of all, we need to make this option available in the Excel top ribbon, and after that, we can use the checkbox control. Below is a step by step procedure for adding a checkbox to Excel:

  • Navigate to Excel Options > Customize Ribbon: With the Excel sheet opened, navigate to “File”> “Options”> “Customize Ribbon” tab. You can also press the keys “ALT + F + T” to open the excel options and then navigate to the “Customize Ribbon” tab.

Adding Excel CheckBox

  • Enable Developer Tools Tab: By default, “Developer” option would be unchecked in the “Main Tabs”. Check the “Developer” option and click the “OK” button.
  • Go to Developer Tab > Insert Option > Checkbox Option: After this, you will be able to see a “Developer” tab on your Excel ribbon. Inside the “Developer” tab, click on the “Insert” dropdown and select the form “Checkbox” control as shown.

Inserting a checkbox in excel

  • Click the Checkbox Option: Now, you can draw a checkbox anywhere on your excel sheet.
  • Format Checkbox Control: Next, you can customize your checkbox using the “Format Control” option.

How to Capture the Checkbox State

After adding the checkbox to your spreadsheet, you need to capture its state. Checkbox state can tell you if the checkbox is currently checked or not.

For capturing the state of a checkbox, you need to associate it with a cell. After associating the checkbox with a cell, the cell displays ‘True’ if the checkbox is checked; otherwise, it displays ‘False’.

To associate checkbox to a cell, follow the below steps:

  • Right-click over the checkbox and select the option ‘Format Control’ from the context menu as shown.

Format Control Option Checkbox

  • Clicking on the ‘Format Control’ option will open a ‘Format Control’ window. Inside the ‘Format Control’ window navigate to the ‘Control’ tab.

Setting a Cell Link For Checkbox

  • On the control tab, click on the ‘cell link’ input box and then select an empty cell on the spreadsheet which you wish to associate with the checkbox.

Checkbox with cell link

Tip: To keep track of the cell links for corresponding checkboxes, it’s always a good idea to set the cell links in a column adjacent to the checkbox. This way, it gets easier to find the cell links associated with the checkboxes whenever you want. Also, you can hide the column containing the cell links so that your spreadsheet is clutter-free.

How To Insert Multiple Checkboxes Fast in Excel

In the above sections, we saw, how to add a single checkbox to excel, but there can be times where you would need to have tens or hundreds of checkboxes in your worksheet. Adding such a huge number of checkboxes on by one is not a feasible option.

So, let’s see how can we add multiple checkboxes to excel fast:

  • First of all, add a checkbox manually, by selecting the checkbox option from the Developer tab.

Drag the excel checkbox control

  • Next, adjust the position of the checkbox.

Adjust the excel checkbox position

  • Optional Step: Format the checkbox as required. In this example, we are setting the checkbox text as blank.

Format the excel checkbox as desired

  • After this, right-click over the checkbox and select the ‘Format Control’ option from the context menu.

Open the Format Control option for excel checkbox

  • In the ‘Format Control’ window, navigate to the ‘Properties’ tab and check if the option “Move but don’t size cells” option is selected. If this option is not selected, select it and click the “OK” button.

Alignment option for excel checkbox

  • Finally, when the check box is positioned correctly and formatted correctly. Drag the fill handle to all the rows below.

Drag the fill handle to copy the checkboxes

  • And it’s done! Now you will see checkboxes copied against all the rows.

Adding Excel Checkbox Fast

As you can see in the screenshot above, we have inserted checkboxes for all the rows in our list. But the list cannot be used as such, because we still haven’t set the cell links for all those checkboxes. Now let’s see how to add cell links for multiple checkboxes.

Setting the Cell Link for Multiple Checkboxes

Setting cell links for multiple checkboxes manually can become very tedious. So, we can use a VBA code that can set checkbox cell links for multiple checkboxes in excel.

Follow the following steps to use this VBA code:

  • With your Excel workbook opened, Press “Alt + F11” to open Visual Basic Editor (VBE).
  • Right-click on the workbook name in the “Project-VBAProject” pane and select Insert -> Module from the context menu.

open the vba editor

  • Copy the following VBA code:
Sub LinkCheckBoxes()
Dim chk As CheckBox
Dim lCol As Long
lCol = 1 'number of columns to the right for link

For Each chk In ActiveSheet.CheckBoxes
chk.LinkedCell = chk.TopLeftCell.Cells.Offset(0, lCol).Address
Next chk
End Sub

Note: Depending on the offset between the checkbox and the column where you wish to set the cell links set the value of ‘lcol’ column. In this example, we have set it to 1, which means, the cell links will be generated in the column next to the checkboxes.

VBA Code for setting checkbox cell links in bulk

 

  • After doing the changes, run the code using ‘F5’ key.

setting multiple checkbox cell links animation

  • Close the VBA editor, and you would see the cell links for all the checkboxes are generated.

How to Insert Multiple Checkboxes Without Developer Tab

In the above sections, we have seen how to add checkboxes from the developer tab. In this section, we will see how you can add multiple checkboxes to excel without using the developer tab.

For this, we can use a VBA script, that accepts the range where the checkbox needs to be included and the cell link offset as user inputs, and based on these inputs the VBA script creates the checkboxes in the specified range.

Let’s see how to use this VBA script:

  • With your Excel workbook opened, Press “Alt + F11” to open Visual Basic Editor (VBE).
  • Right-click on the workbook name in the “Project-VBAProject” pane and select Insert -> Module from the context menu.

open the vba editor

  • Copy the following VBA code:
Sub CreateCheckBoxes()
'Declare variables
Dim c As Range
Dim chkBox As CheckBox
Dim chkBoxRange As Range
Dim cellLinkOffsetCol As Double
'Ingore errors if user clicks Cancel or XOn Error Resume Next
'Input Box to select cell Range
Set chkBoxRange = Application.InputBox(Prompt:="Select cell range", Title:="Create checkboxes", Type:=8)
'Input Box to enter the celllink offset
cellLinkOffsetCol = Application.InputBox("Set the offset column for cell links", "Cell Link OffSet")
'Exit the code if user clicks Cancel or X
If Err.Number <> 0 Then Exit Sub
'Turn error checking back on
On Error GoTo 0
'Loop through each cell in the selected cells
For Each c In chkBoxRange 'Add the checkbox
Set chkBox = chkBoxRange.Parent.CheckBoxes.Add(0, 1, 1, 0)
With chkBox
'Set the checkbox position
.Top = c.Top + c.Height / 2 - chkBox.Height / 2
.Left = c.Left + c.Width / 2 - chkBox.Width / 2
'Set the linked cell to the cell with the checkbox
.LinkedCell = c.Offset(0, cellLinkOffsetCol).Address(external:=True)
'Enable the checkBox to be used when worksheet protection applied
.Locked = False
'Set the name and caption
.Caption = ""
.Name = c.Address
End With
Next c
End Sub

Inserting checkboxes in excel without developer tab

 

  • After doing the changes, run the code using ‘F5’ key.

Checkbox-Without-Devtools-Animation

  • Select the checkbox range and enter the desired cell link offset, and the checkboxes would be created.

How to Delete a Checkbox in Excel

Deleting a single checkbox is relatively straightforward – select the checkbox and press the delete button on your keyboard.

Option 1: Using ‘Ctrl’ key to delete multiple checkboxes

If you want to delete multiple checkboxes from your spreadsheet, follow the below steps to delete them:

  • 1. Press the ‘ctrl’ key on the keyboard and click on checkboxes you wish to delete. Doing this will select the clicked checkboxes, as shown.

Selecting multiple checkboxes with ctrl key

  • 2. Next, press the delete key on the keyboard and all the selected checkboxes will be deleted.

Option 2: Using ‘Selection Pane’ to delete multiple checkboxes

Another way to delete multiple checkboxes in excel is by using the selection pane. Follow the below steps:

  • On the spreadsheet, in the “Home” tab > “Editing” section. Click the “Find and Select” option in the ribbon and select the “Selection Pane” option from the context menu.

Selection pane

  • From the selection pane, select all the checkboxes that you wish to delete and press the ‘Delete’ key.

Selecting checkboxes using selection pane

Option 3: Using ‘Go To Special’ to delete multiple objects

If you wish to delete all the excel checkboxes from a sheet, then you can make use of the select all objects option. But another point that you should note is – this approach would delete all the other objects like shapes, dropdowns, charts, dropdowns, etc. present in the active sheet.

Follow the below steps:

  • On the spreadsheet, in the “Home” tab > “Editing” section. Click the “Find and Select” option in the ribbon and select the option “Go To Special”

Find and Select Option In Excel

  • On the “Go To Special” window, select the option “objects” and check the “OK” button. Doing this will select all the objects present in the active sheet.

Deleting all form objects using Go to special

  • Finally, press the delete key from the keyboard, and all the objects will be deleted.

Option 4: Using VBA Macro to Delete Multiple Checkboxes

If you have a lot of checkboxes in your spreadsheet and only want to delete the checkboxes (not all the objects), then this is the option for you. Below is a script that will delete all the checkboxes from your active sheet.

Follow the below steps:

  • With your Excel workbook opened, Press “Alt + F11” to open Visual Basic Editor (VBE).
  • Right-click on the workbook name in the “Project-VBAProject” pane and select Insert -> Module from the context menu.

open the vba editor

  • Copy the following VBA code:
Sub DeleteCheckbox()
For Each vShape In ActiveSheet.Shapes
If vShape.FormControlType = xlCheckBox Then
vShape.DeleteEnd If
Next vShape
End Sub

VBA Code to delete multiple checkboxes

  • After doing the changes, run the code using ‘F5’ key and all the checkboxes present in the active sheet will get deleted.

How to Edit Checkbox Text

Editing checkbox text or checkbox caption is straightforward. To edit checkbox text, you need to right-click over the textbox and select the option “Edit Text.”

Edit Checkbox Name

Doing this will move the cursor at the beginning of the checkbox caption and allow you to edit it as follows.

Checkbox-Rename-Animation

Perfect!

But wait! Notice how the text displayed in NameBox is still the same, even though the checkbox text is changed.

Difference Between Checkbox Caption and Checkbox Name

The text in front of the checkbox is called checkbox ‘caption’, whereas the name that you see in the NameBox is the backend ‘name’ of the checkbox.

When you click the “Edit Text” option by right-clicking over the checkbox control, it only changes the caption of the checkbox.

checkbox name vs caption

However, if you want to change the backend name of the checkbox, you need to right-click over the checkbox and then type a suitable name in the NameBox.

Formatting a Checkbox Control in Excel

Although there are not many things that you can do to make your checkboxes stand out, still there are a few customizations that can be done. Following a list of customizations that excel allows with checkbox controls:

Selecting Background Color and Transparency for Checkbox Control

To choose a background color for your checkbox – right-click over the checkbox and click on the option “Format Control”. Inside the “Format Control” window > “Color and Lines” tab > “Fill” section, you can choose a background color and desired transparency for your checkbox.

Formatting a checkbox in excel

Selecting Border Color for the Checkbox Control

To create a checkbox border – Inside the “Format Control” window > “Color and Lines” tab > “Lines” section you can choose a border for your checkbox.

Choosing a 3D Shade Effect for Checkbox Control

To give your checkboxes a slight 3D effect – Inside the “Format Control” window > “Control” tab > 3-D shading option.

3D shading effect for Excel checkboxes

ActiveX Checkboxes In Excel

Until now, in this article, we have only talked about Excel Form Checkbox, but there is another type of checkbox that Microsoft Excel makes available – that is known as ActiveX Checkbox.

Form Checkbox vs ActiveX Checkbox in Excel

ActiveX checkboxes can also be added from the “Developer” Tab > “Insert” button. Also, in most aspects, an ActiveX checkbox is very similar to a form checkbox, but there are some critical differences between the two:

  1. ActiveX checkboxes provide more formatting options. In ActiveX checkboxes, you can change the checkbox caption font, have an image as a background, change the mouse pointer while it hovers over the checkbox, etc.
  2. ActiveX controls are external components and hence are loaded separately this sometimes causes them to freeze or become unresponsive. On the other hand, Form controls are built into Excel, and therefore they do not have any such issues.
  3. ActiveX is a Microsoft-based technology and is not supported by other operating systems like Mac.
  4. Also, many computers don’t trust ActiveX by default, and ActiveX controls are disabled unless you add them to the Trust Center.
  5. Another essential difference between the Form controls and ActiveX controls is that – ActiveX controls can be directly accessed as objects in the VBA Code (faster) whereas to access form controls you need to find the form controls on the active sheet (slower).

How to Assign a Macro to a Checkbox

We have already seen how to associate cell links with checkboxes in excel and perform actions based on the checkbox value. Now, let’s understand how to assign macros with checkboxes and execute the macros when the checkbox is clicked.

To associate a macro with the checkbox, follow these steps:

  • Right-click over the checkbox and click the option “Assign Macro”

Adding a macro to excel checkbox

  • On the “Assign Macro” window, give a meaningful name to the macro and click the “New” button, this will open the VBA editor.

Assigning a macro to excel checkbox

  • On the VBA editor, you can write the macro. For the sake of this example, we will be writing a macro that toggles the visibility of A Column. If the column is visible clicking the checkbox will hide it else if the column is hidden clicking the checkbox will unhide it.

Adding macro to excel checkbox that hides column A

  • The VBA code is as follows:
Sub ToggleAColumnVisibility()
If ActiveSheet.Columns("A").Hidden = True Then
Columns("A").Hidden = False
Else
Columns("A").Hidden = True
End If
End Sub
  • Save the macro and close the VBA editor.

Checkbox with macro animation

  • Now, try clicking on the checkbox and see how to toggles the visibility Column A.

Another example of using macro with excel checkbox: Selecting All Checkboxes using a Single Checkbox in Excel

Practical Examples of Using Checkboxes in Excel

Now let’s see some of the practical examples of excel checkboxes:

Example 1: Using Excel Checkboxes to Track Stock Availability for a Store

Inserting a Checkbox with example

In the above example, we have a list of grocery items, with a checkbox against each one of them. The checkbox indicates the availability status of the item. As soon as the item is checked a label “Available” gets populated in-front of it and for unchecked checkboxes, a title “Out of Stock” is shown.

This is done simply by using built-in checkbox functionality and if statements. To accomplish this first, we have inserted a checkbox in the sheet and then selected its ‘cell link’ as the corresponding cell in range “E:E”.

For instance, the ‘Cell link’ for checkbox at “B3” cell is “$E$3”. And similarly, the ‘Cell link’ for checkbox at “B9” is “$E$9”. This means – when the “B3” checkbox is checked the value at the “E3” cell will change to “True” otherwise the value will be “False”.

Checkbox example Demo

Secondly, we have used an if based formula in front of these cells. The formula is:

=IF(E2=TRUE,"Available","Out of Stock")

The job of this IF statement is simply to read the value of the corresponding cell in “E:E” range and if its value is “True” then it displays a message “Available” otherwise the message will be “Out of Stock”.

For instance, if the checkbox at ‘B6’ is checked so the value at ‘E6’ will be “True” and hence the value at ‘C6’ will be “Available”.

Later, we have used an Excel Countif Function to find the total number of available items.

=COUNTIF(C2:C11,"Available")

And a similar COUNTIF Function is used for finding the total number of items unavailable:

=COUNTIF(C2:C11, "Out of Stock")

Example 2: Using Excel Checkboxes to create a To-Do List

Creating a Todo List with checkbox in Excel

In this example, we have a to-do list with tasks and their corresponding statuses represented by checkboxes. For each checkbox, the related cell link is set in the D-column in front of the checkbox.

Finally, in the summary section, we have counted the total number of tasks using the formula:

=COUNTA(D3:D13)

For calculating the completed tasks we have made use of the cell links, all the cell links with a value TRUE are considered to be associated with completed tasks. And based on this we have come up with a formula:

=COUNTIF($D$3:$D$13,TRUE)

Event to do checklist animation

Completed task percentage is calculated by using a simple percentage formula, i.e. (number of completed tasks/number of total tasks)*100 :

=B19/B18%

So, this was all about inserting and using a checkbox in Excel. Please feel free to share any comments or queries related to the topic.

About Ankit Kaul

Ankit is the founder of Excel Trick. He is tech Geek who loves to sit in front of his square headed girlfriend (his PC) all day long. :D. Ankit has a strong passion for learning Microsoft Excel. His only aim is to turn you guys into 'Excel Geeks'.

Comments

  1. Hi Ankit,

    You have no idea how much value you are spreading in the world, where anyone can use your website to do something new and amazing with excel, and go home happy.

    Keep up the good work buddy.
    Sudeep

  2. Tiffany Whitesays

    Thank you for your explanation of checkboxes. You really make it easy to understand.

    I was wondering if there was a way to only have the items that are checked to be on a final list. I am making a price sheet and have a master list of the prices but not all items are used for the final sales sheet, only the items that are checked need to be on the final list. Is this possible?

    Thank you!
    Tiffany

    • Hi Tiffany, Yes it is very much possible. You can do this by cleverly using IF Statements with ‘cell link'(i.e. check value) .
      Please check your email as I have sent you a sample spreadsheet to solve this problem.

  3. This was awesome!!!!!!

  4. Heey!

    Thanks for the tut, I have a question. Now you have a bunch of checkboxes but can you make a checkbox above the entire row that select or deselect the entire row of checkboxes?

    gr Cheraine

    • Hi Cheraine, its a good question. For this you need to write a small macro on the click event of the master checkbox. I have created a spreadsheet for doing this please download it [here]. I will also come up with a detailed post on this. So, keep visiting. 🙂

  5. Toye Omilabusays

    How can I group checkboxes and how can I make it such that only one checkbox can ticked/selected at a time from the group

    • Hi Toye, In such a case I would suggest you to go for radio buttons. The fundamental difference between checkboxes and radio buttons is that: Checkboxes allow users to choose multiple options from a group (i.e. they can check multiple checkboxes), while radio buttons allow user to choose exactly one item from a group.
      Radio buttons are also available in the Developer Tab. Hope it helps :).
      Please let me know in case you need any other help from my end.

  6. Awesome Ankit!!!

  7. Rajiv Vishwasays

    Tutorial is great but better that is the follow up you do on each and every comment.
    Kudos for that.

  8. Hi I’d like to add checkboxes too but I realize that my 2007 version does not have the ‘customize ribbon’ option. Does that mean I can’t add checkboxes? Thanks in advance!

  9. Hi I’ve found the answer. Just in case anyone has the same problem, go to Excel Options, under ‘Popular’, check ‘Show Developer Tab in Ribbon’. Thanks for the tutorial Ankit! Now I’m off to creating my checkboxes.

  10. I copied a table of data with included checkboxes — which I don’t need or want — so I simply want to delete them. It’s not obvious or easy — they won’t go away. I’ll take your suggestions for insertion; and hopefully find a way to deactivate and remove them. Thanks.

    • Hi Jim, there is a much easier way to delete multiple check boxes:
      1. First on the Home Tab navigate to ‘Find and Select’ > ‘Go To Special’.
      2. Now in the ‘Go To Special’ window, select the ‘Objects’ radio button and click ‘Ok’.
      3. This will select all the check boxes in the sheet, and now simply press the delete key from the keyboard to delete them.
      Hope it helps 🙂

  11. Hi Ankit.

    Very informative guide, thank you.
    A very random way to add a Tick or Cross to a Cell, is to change the Font of the Cell to Windings2. An “O” makes a Tick, and a “P” makes a Cross. You’re welcome to add that to your guide.

    Normal Wingdings also have a Tick and a Cross, but the characters are “ü” and “û”, which is a bit harder to just type in.

    Thank you again for the awesome guides!

  12. Ankit, what is the difference between a “Form Control” or an “Active-X Control”?

    Currently i’m using the last column on a spreadsheet as a way to set off certain equations. So that if in F5 it says “Credit” it applies it to the credit card payments column, if it says “Cash” to the cash column, and lastly “check” to the check column. Most of the columns have large nested if statements in them that follow different rules on how to sum and apply to current balances for our customers. Originally if I had known how to use check boxes I would have done that and am still considering moving it back to that solution. The problem I come across though is that a check box only allows me two options (True/False) I would need more then one check box to let there be all 3 options correct? (And once I need two it would be easier to explain as 3) This seems to start becoming more cumbersome and space consuming where as my current solution is only taking up a single cell. Are there any other Form Controls that are as useful as the check box that would accomplish this task in a non intrusive manner?

    • Hi Madds,

      The main difference between Form Controls and ActiveX controls is that:
      Excel responds to a Forms control only after the user finishes interacting with it where as it continuously responds to an ActiveX control. And you can use form controls on worksheets as well as on charts but ActiveX controls can only be added on worksheets.

      And for your case, I think you can try using something like excel drop-downs or combo-boxes.
      As they have multiple states (values).

  13. Hi Ankit,

    I have to create a list of hundreds of checkboxes.
    To do it faster than one by one, I copy the cell containing my first checkbox and paste it in all my lines.
    But… all these boxes are linked (checking one make all of them getting checked :/ )

    Do you have a tip to create multiple independant check boxes in a quick way ?

    Thanks a lot for your work

    A

    • Hi Malus,
      Instead of copying the checkboxes you can try, selecting the cell where the checkbox is present. And then drag the fill handle over the range of cells where you need to have the checkboxes.
      Hope it helps 🙂

      • I was able to successfully copy multiple checkboxes using the suggested method, but now all of the checkboxes are “linked” to the same reference field.

        • Hi Danielle,
          That is because before dragging the first checkbox you would have already added its cell link.
          But, no worries! Use the below macro and it will correct the cell links.

          Sub Modify_Cell_links()
          Dim CB As CheckBox
          Dim Row As Integer
          Dim Clm As Integer
          Row = 4 'row number of first linked cell
          Clm = 5 'column number of first liked cell
          For Each CB In ActiveSheet.CheckBoxes
          CB.LinkedCell = ActiveSheet.Cells(Row, Clm).Address
          Row = Row + 1
          Next CB
          End Sub

          Please note that here you need to change the values of ‘Row’ and ‘Clm’ variables.
          For instance, if for your first checkbox you want the A5 as cell link, then ‘Row’ should be 5 and ‘Clm’ should be 1.

          Hope it Helps 🙂

  14. This is Simply AWESOME!

  15. Hi Ankit,
    How do i get a sum of the number of checkboxes that are checked? I saw your example above but i dont have an IF statement associated with the checkbox, only a CHECKBOX.
    Thanks

    • Hi Dan,
      For getting the sum of checked checkboxes you can simply use the count if function as:
      =COUNTIF('Range of cell links',"True")
      Where ‘Range of cell links’ indicates the cells that contain the cell links to your checkboxes.
      Hope it helps 🙂

      • Hi Ankit,
        This did help, but the problem im running into is i have a series of check boxes in a row, like 100 of them. So i ran into the problem with the true false function since i have multiple series of check boxes.

        • Hi Dan, I guess this should not be an issue unless you have used a single cell as the ‘cell link’ for all the checkboxes present in a row.
          So, what I suggest is like:
          1. First insert the checkboxes horizontally (i.e. in a single row).
          2. And then for cell links use the cells in the following row, under corresponding checkboxes.
          3. So after this you will have checkboxes in first row and their corresponding cell links below them.

          This will help you to apply the formula and will give correct results. 🙂

      • Thanks for your help! appreciate it!

  16. Hi Ankit

    Is there a way to get the sum of checked checkboxes if there is no cell link? My co-worker created the spreadsheet so I’m not sure what method he used to create the checkboxes and I know very little about excel.

    Thanks.

    • Hi Liz,
      Yes their is a way, but I think updating the ‘cell link’ property of already existing checkboxes would be much simpler.
      Anyways that’s your choice, so here is the second way to do this.

      1. Press Alt + F11 to open the VBA editor. Next navigate to ‘Insert’ > ‘Module’.
      2. Now in the Editor paste the following code:

      Sub Find_Checkbox_State()
      Dim CB As CheckBox
      Dim Checked_box As Integer
      Checked_box = 0
      For Each CB In ActiveSheet.CheckBoxes
      If CB.Value = 1 Then
      Checked_box = Checked_box + 1
      End If
      Next CB
      MsgBox "Currently " & Checked_box & " checkboxes are in Checked State."
      End Sub

      3. Run this code using ‘F5’ key and it will give you the number of checked checkboxes in the Active Sheet.
      4. Alternatively, you can also add this macro on the click event of a button for making it easier to use.

      Hope it helps 🙂

  17. Thank you so much for this tutorial! My only question: how do I get rid of the “Check Box 1” text label after the checkbox?

  18. Hi Ankit,

    Could you please tell me the Excel Vb script to Delete a Checkbox?
    Eg: I would like to delete a checkbox from the cell “C38” which is also linked to the same cell.
    I have got the code to delete multiple checkboxes, but just cant seem to delete 1 particular checkbox 🙁

    ‘Code to Delete all checkboxes in a sheet
    For Each vShape In ActiveSheet.Shapes
    vShape.Delete
    Next vShape

    • Hi Tanu,
      In your case the below mentioned code will work.

      Sub DeleteCheckbox()
      For Each vShape In ActiveSheet.Shapes
      If vShape.TopLeftCell.Address = "$C$38" And vShape.FormControlType = xlCheckBox Then
      vShape.Delete
      End If
      Next vShape
      End Sub

      I have tested the code myself and it works.
      Please let me know in case you face any issues.
      Hope it helps 🙂

Privacy Policy | Disclaimer | About