How do you assess the state of a form-checkbox in a logic statemen

J

jvatlanta

Can anyone give an example of accessing the logic state of a form-checkbox
(true-false) for use in an IF statement?
 
S

Squeaky

Whatever cell the checkbox is linked to can be used in your IF statement.

If the checkbox is tied to say cell a1, in another cell if you put
"=if(a1=true,"Happy","Sad")" (without quotes) as you check and uncheck the
box the other cell will change from Happy to Sad.

Squeaky
 

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

how can I lock/unlock a range of cells depending on state of a checkbox? 4
VBA word change keys 0
MATCH not working in IF statement 6
checkbox triple state 1
How can I test the text content of a cell 4
Macro to select, set, and print 12
If Statement with Two Different Logical Test 16
Logical value in time formula? 4

Top