This is another method to insert a checkbox, you can use following VBA code. ActiveSheet.CheckBoxes.Add(left, Right, Height, Width).Select ActiveSheet.CheckBoxes.Add(80, 40, 72, 72).Select. Using above method is only helpful when you exactly know about the place to insert and size of the checkbox. Learn more about this method from here. Making Excel checklists. We would like to create the following task list: Write your tasks in column A as shown above. Under Developer option click Insert and then click check box which is placed under form control. Select the required cell to place the check box. To remove Check box 1, click on text and delete it.
You can use Word to create a simple To Do list. If you like, you can even print checkbox controls next to each item. There are two ways to add checkbox controls and how you'll use them determines which method you'll use.
LEARN MORE: Office 365 Consumer pricing and features
Only for printing
What's Hot at TechRepublic
If you plan to print your list and use a pen or pencil to mark each item as you complete it, you can add checkbox controls instead of bullets, as follows:
- Select the list.
- Click the Home tab if necessary.
- Click the Bullets dropdown in the Paragraph group. (Don't just click the option; doing so will automatically insert the default bullet.)
- Choose Define New Bullet from the dropdown list.
- In the resulting dialog box, click Symbol.
- Choose Wingdings from the Font dropdown.
- Select the checkbox in the first row.
- Click OK twice.
![Add Checkbox Excel 2016 Add Checkbox Excel 2016](/uploads/1/2/5/7/125780689/998796686.png)
In Word 2003, select the right-click the list and choose Bullets and Numberings from the resulting shortcut menu. Choose any bullet style and click Customize. Click Character in the resulting dialog box. Continue with step 6 above.
Word will replace the default bullet character with the selected checkbox. This particular symbol won't let you check anything in the actual document, but it's great for printing.
SEE: Cost comparison calculator: G Suite vs. Office 365 (Tech Pro Research)
Content control
If you want the capability to check the checkbox within the Word document, use a content control (in Word 2003, use a Forms field). These controls are available on the Developer tab, which isn't visible by default. To display the Developer tab, if necessary, do the following:
- Right-click anywhere on the ribbon's background and choose Customize The Ribbon.
- Check the Developer item in the list to the right.
- Click OK.
Once the Developer tab is available, you can add a checkbox content control, as follows:
- Position the cursor where you want the first control. (Don't select the entire item; doing so will delete the item).
- Click the Developer tab.
- Click the Checkbox content control in the Controls group.
Unfortunately, you can't insert content controls to the entire group of items, as a group, similar to the way you'd add bullets. You must insert each control individually. Selecting the checkbox content control toggles between checked and unchecked. Don't limit checkboxes to just To Do lists - anytime you have a two-state choice, consider using a checkbox.
Microsoft Weekly Newsletter
Be your company's Microsoft insider with the help of these Windows and Office tutorials and our experts' analyses of Microsoft's enterprise products. Delivered Mondays and Wednesdays
Sign up today Sign up today Also see
- How to add a drop-down list to an Excel cell (TechRepublic)
- 10 all-purpose keyboard shortcuts to boost your Word efficiency (free PDF) (TechRepublic)
- Six clicks: Microsoft Word tricks to make you an instant expert (ZDNet)
- 10 Microsoft Word tips to boost your productivity and help you get more work done (TechRepublic)
- Microsoft Office tip: The new AutoSave may not be as useful as you think (ZDNet)
- Six tips for fitting Word content on a single page (TechRepublic)
Affiliate disclosure: TechRepublic may earn a commission from the products and services featured on this page.
I have a workbook that has a few dozen checkboxes. Almost all of these checkboxes are linked to a True/False value in a different cell, though I don't think that necessarily matters. I've seen it happen with unlinked checkboxes. We're testing 2016 versions for an organization-wide rollout and this is a blocker. The end users are not tolerant of malfunctions.
Sometimes checking the box is fine, but often it is frustratingly hard to get it to register the click. Although I have seen it in OS X Maverics (10.11.x), it seems markedly worse in Sierra (10.12.2). It sometimes takes 4 or more clicks for it to register.
This happens on multiple machines with the latest version of Excel 2016 - 15.29.1. At first I thought it was because the workbook was created in 2011, but it happens even with a brand new workbook.
Steps to reproduce:
1) Create a brand new workbook
Steps to reproduce:
1) Create a brand new workbook
2) From the Developer Tab (once enabled) - add a checkbox.
3) Link the checkbox to a cell under Format Control
3) Link the checkbox to a cell under Format Control
4) Start clicking.. see what happens.
The success rate of a click varies widely in my testing. If it doesn't fail right away, just keep doing stuff in the workbook and try again.
![Checkbox Checkbox](/uploads/1/2/5/7/125780689/327548941.png)
I have tried every setting under 'format Control'. I have also tried linking to a VBA procedure rather than using the format control link to a cell. It made no difference.
Here's a video displaying the problem. The circle indicates a system-registered mouse click. (The Button (A2) works fine, I just put that in for comparison.)
https://www.dropbox.com/s/zovf3t6uqj96rc2/ClickFail.mov?dl=0
If anyone has encountered this and has a way to fix it, let me know. I'm running a base-line system with no special fonts or anything.
Thanks.
Thanks.