Check Box Values

  • Thread starter Thread starter Jasmine
  • Start date Start date
J

Jasmine

I have a check box on my worksheet that I have linked to a
cell. Depending on it's state it displays either TRUE or
FALSE. Is there anyway to have it display a 0 or 1?
Thanks for the help!
 
You could link the checkbox to another cell (hidden or well out of th
line of sight) and then put this formula in the cell where you want i
to be 0 or 1.

= --A1000

(thats equals, minus, minus, your linked cell).

The double negation converts a logical (true/false) to a number (0/1).
If you are doing this to be able to use the cell in a calculation, jus
leave it as true/false and put the double negation in your formula.
 
Thank you very much! I put it in the formula and it works
great! Thanks again!
 
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

Some trouble assigning a string to a variable 22
combo box 2
Display check mark value 1
How to hide password? 1
Retrieving the values of Excel check boxes in .NET 4
Access 2010 0
Code to display a true or false value in the cell containing a check box 1
True or False for a check box 4

Back
Top