Jump to content

Create check boxes


Recommended Posts

Create check boxes

Looking for a great way to get a yes or no decision from an end user? Try presenting your question in the form of a check box. If the box is checked, the answer is yes. You can store the result of that decision as a value in a cell and use that value in your code or calculations.

To demonstrate how the check box works, open a blank worksheet, go to View | Toolbars, and choose Forms. Click the Check Box tool once, then click and drag in the worksheet to draw a check box. When you release, click the Forms toolbar's Control Properties tool, or right-click the new check box and choose Format Control.

You'll have plenty of time later to tweak the text associated with the check box. Your first order of business is to tell Excel where to store the check box's "state." To do so, click the Control tab, enter A1 in the Cell Link field, and click OK.

As you click the check box, you'll see the value in A1 change to TRUE when checked and to FALSE when unchecked. You can use that value in your formulas. For example, you can display a custom message with a formula like the following:

=IF(A1,"Checked message","Unchecked message")

By the way, the check box Control Properties also lets you set the initial value (state) for the check box. If you choose Mixed, the check box will initially appear grayed out and return a value of #N/A to the linked cell, which tells you that the item is neither checked nor unchecked.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...