How to Insert Multiple Checkboxes

This post will teach you how to quickly insert or add multiple checkboxes in excel. How to add one checkboxes in one cell in Excel. How to add multiple checkboxes with Fill Handle or with VBA Macro in Excel.

Add a checkbox in one cell

If you want to add one checkbox in a cell, you can do it as following steps:

1# go to Developer Tab, then click Insert command under Controls group, select Check Box.

insert multple checkboxes1

2# click one cell that you want to insert the checkbox. And it will appear in that cell.

insert multple checkboxes2

3# you can move the cursor to drag the checkbox to the desired position.


Insert multiple checkboxes with Fill Handle

If you want to quickly add multiple checkboxes in Excel, you can use the Fill handle to create multiple checkboxes based on one checkbox that has been created. Refer to the following steps:

1# insert one checkbox as described above

2# move the checkbox into a cell, then select that cell, Drag the Auto Fill Handle over the range of cells that you want to fill.

insert multple checkboxes3

3# you will see that multiple checkboxes have been added in each cell.

insert multple checkboxes4

Insert multiple checkboxes with VBA code

You can also write a new excel macro to quickly add multiple checkboxes in Excel VBA, just do the following:

1# click on “Visual Basic” command under DEVELOPER Tab.

Get the position of the nth using excel vba1

2# then the “Visual Basic Editor” window will appear.

3# click “Insert” ->”Module” to create a new module

convert column number to letter3

4# paste the below VBA code into the code window. Then clicking “Save” button.

insert multple checkboxes5

Sub addMultipleCheckBoxes()
    Dim R As Range
    Dim wr As Range
    Dim wsheet As Worksheet
    i = 1
    On Error Resume Next
    xTitleId = "addMultipleCheckBoxes"
    Set wr = Application.Selection
    Set wr = Application.InputBox("Range", xTitleId, wr.Address, Type:=8)
    Set wsheet = Application.ActiveSheet
    Application.ScreenUpdating = False
    For Each R In wr
        With wsheet.CheckBoxes.Add(R.Left, R.Top, R.Width, R.Height)
            With Selection
               .Characters.Text = R.Value
               .Caption = ""
               .Caption = "Check Box" & i
               i = i + 1
           End With
        End With
    Application.ScreenUpdating = True
End Sub


5# back to the current worksheet, then run the above excel macro.

insert multple checkboxes6

insert multple checkboxes6

insert multple checkboxes6

Change the checkbox name and caption name

When you create a new checkbox, the default caption name is like as CheckBox x. so if you want to change the caption name, you just need to right click the checkbox, select the Edit Text from the drop-down menu, and then type the name that you want to set.

insert multple checkboxes9

insert multple checkboxes9

If you want to change the checkbox name, you just need to select the checkbox, then type the desired name in the Name box, it will change immediately.

insert multple checkboxes11



So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *