Creating a Check Box

  • Thread starter Thread starter Jonesj18
  • Start date Start date
J

Jonesj18

I would like to learn how to create a check box. Is there
a way to do that?
 
The simplest checkbox (I think) is from the Forms toolbar.

So View|tool bars and show that Forms toolbar.

Click on the checkbox and then click on the topleft corner where it should be
placed. Then draw to the opposite lowerright corner.

When you've placed it correctly, right click on it and select "Format Control"
On the Control Tab, you can assign a cell link that you can use to determine if
the checkbox is checked or not.

=if(A1=True,"It's checked","It's not checked")

(If I chose A1 as my linked cell.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forms Check Box cell link 4
How to create a checkk box? 2
check box macro 1
sum of check boxes that have been checked 2
How to Start a Macro by physically checking a check box? 3
Excel 2007 Insert Check Boxes to an Entire Column 3
Making a "Check Box" Larger 1
check box 1

Back
Top