How to create Yes or No checkboxes in Excel?

If you need to create a list of Yes/No checkboxes and make them mutually exclusive to each other, a method in this article can help you.

Create Yes/No checkboxes by grouping radio button

• Go to tab 'Developer' and and press with left mouse button on 'Insert' button and then 'Check boxes (form control)'. Draw a check box in cell B3. Remove check box text. Use arrow keys to position checkbox 1 px incrementally. Press and hold with left mouse button black box in the bottom right corner of cell B3.
• How the VBA code works. When the VBA code below is run it will display two Input Boxes. From the first Input Box select the range of cells in which to create the checkboxes, then click OK. In the screenshot below, it will create 30 checkboxes, being one in each cell from A1 – C10. The second Input Box (shown below) will set the default value.
• To insert a checkbox in Excel, do the following: On the Developer tab, in the Controls group, click Insert, and select Check Box under Form Controls or ActiveX Controls. Click in the cell where you want to insert the checkbox, and it will immediately appear near that cell.

Please do as follows to create Yes/No checkboxes in Excel worksheet.

Article: how to insert a checkbox into excel 2016 Thinking How To Insert A Checkbox Into Excel 2016 to Eat? We've got you covered. These easy recipes are all you need for making a delicious meal. Find the How To Insert A Checkbox Into Excel 2016, including hundreds of ways to cook meals to eat. All the best to you.

1. Click Developer > Insert > Group Box (Form Control). See screenshot:

Note: Please display the Developer tab in your Excel if you need..

2. Then insert a Group Box into the worksheet.

3. Repeat the above steps to insert a list of Group Boxes as below screenshot shown.

4. Click Developer > Insert > Option Button (Form Control) to insert a radio button into the Group Box. See screenshot:

5. After inserting two radio buttons into a Group box, repeat the above step 4 to finish inserting all radio buttons into the Group Boxes. See screenshot:

6. Then you can hide the borders of all Group boxes with below VBA code as you need. Press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window. In the window, click Insert > Module, then copy and paste below VBA code into the Module window.

VBA code: Hide border of Group Boxes

7. Press the F5 key to run the code. Then borders of all Group boxes are hidden immediately. Please change the displayed text of the Radio buttons to Yes/No manually. See screenshot:

Add Checkbox Excel 2016 Download

• Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

• To post as a guest, your comment is unpublished.
  Thank you. This article was very useful.

In the last post, we set up a To Do list with check boxes. Each check box is linked to a cell that’s 2 columns to the right, and we used a macro to set that up quickly. Now we’ll add code so we can click a check box to run a macro.

Click a Check Box to Run a Macro

Here is the To Do list. The check box in column B is linked to the cell in the same row, in column D – Done.

Today, we’ll create a macro that puts today’s date in the Date column, if you check a box in column B.

Create the Date Macro

The macro will be relatively simple.

• We have to figure out where the check box is, when it’s clicked.
• Then, we’ll find the cell that’s two columns to the right.
• In that cell, we’ll enter the current date, if the check box is checked.
• If the check box was cleared, we’ll clear the date cell.

Here is the code, which uses Application.Caller to identify which check box was clicked. If the box is checked, its value is 1, and we’ll put in the date.

Assign the Macro to a Check Box

First, we’ll see how to manually set up the check box so it runs the CheckBoxDate macro.

• Right-click the check box in cell B4, so the pop-up menu appears (if the Move/Copy popup appears, try right-clicking again)
• Click the Assign Macro command

In the list of macros, click CheckBoxDate, then click OK

Test the Date Macro

Add Checkbox Excel 2016 Free

To test the macro, follow these steps:

• Click away from the check box, to deselect it
• Click the check box, to add a check mark, and the current date should appear in the date column
• Click again, to remove the check mark, and the date cell should be cleared.

Use VBA to Add Macros to All Check Boxes

Instead of manually assigning a macro to each check box, we’ll create a macro that’s similar to the one we used to link all the check boxes to a cell.

In the macro, we’ll set the OnAction property to the date macro name

Run the Add Macros Code

To assign the CheckBoxDate macro to each check box, run the SetCheckBoxesMacro macro.

Add Checkbox Excel 2016

You won’t see a change on the worksheet, but now each check box has the macro assigned to it.

Add Checkbox To Excel 2016

To test the results, click on any one of the check boxes, and the Date cell in that row should change.

Download the Sample File

To see all the code, and the To Do list with check boxes, you can download the sample file from my Contextures website.

On the Sample Files page, go to the UserForms and VBA section, and look for UF0024 – Click Check Box to Run Macro

The zipped file is in xlsm format, and contains macros.

Add Checkbox Excel 2016 To Excel

________________________