How to insert checkboxes in Excel

 371 total views


2021-05-14 08:52:38

Inserting checkboxes in Excel helps to select opinions and content more quickly as we easily sum up through the number of counts. For those who do a survey, adding checkboxes in an Excel data sheet is essential and also creates professionalism. Previously, the network administrator also instructed readers to insert checkboxes in Word with very simple operations and insert checkboxes in Google Sheets. The following article will guide you to read how to insert checkboxes in Excel.

1. Insert checkboxes in Excel with checkboxes

Developer has many useful features to serve advanced requirements, including inserting checkboxes in Excel.

Step 1:

At the interface on Excel, click Developer tab Then look down, in the Controls group you click Insert button then click Check box icon (From control).

Step 2:

Now in the area where you need to insert the checkbox, you need to drag the mouse to create the cell to create a checkbox as shown below.

Create checkboxes

Right-click on the checkbox already created choose Edit Text in the displayed menu. Then you just need to Delete the text displayed in the checkbox Go is okay.

Delete text

Step 3:

Finally, click in the first checkbox and then drag down the remaining boxes. When the recipient of the survey or assessment, just tick the box.

Checkbox

2. How to batch insert checkboxes in Excel

Step 1:

First of all you need highlight the data area need to insert checkboxes for zoning.

Highlighted area

Then also click Developer tab then click on Visual Basic under.

Visual Basic

Step 2:

Switch to the new interface, we click Insert and then select Module under.

Open the interface to insert code

Now display the interface to enter the VBA code below.

Sub InsertCheckBoxes()

‘Update 20140506

Dim Rng As Range

Dim WorkRng As Range

Dim Ws As Worksheet

On Error Resume Next

xTitleId = “KutoolsforExcel”

Set WorkRng = Application.Selection

Set WorkRng = Application.InputBox(“Range”, xTitleId, WorkRng.Address, Type:=8)

Set Ws = Application.ActiveSheet

Application.ScreenUpdating = False

For Each Rng In WorkRng

With Ws.CheckBoxes.Add(Rng.Left, Rng.Top, Rng.Width, Rng.Height)

.Characters.Text = Rng.Value

End With

Next

WorkRng.ClearContents

WorkRng.Select

Application.ScreenUpdating = True

End Sub

When finished importing you Click the Run button in the toolbar above to run the code. Now display the highlighted data area to insert the checkbox, click OK to agree.

Run the code

The results of the checkboxes are automatically bulk inserted into the data area you select.

Insert checkboxes automatically

Video instructions to insert checkboxes in Excel

.

#insert #checkboxes #Excel

Leave a Reply

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