True/False Checkboxes

D

dankim

I've been searching unsuccesfully for an answer to this question for
the past three days. I'm a complete beginner with Excel so please
excuse my ignorance...

I'm trying to make a simple checkbox in my spreadsheet so that when it
is checked the value = TRUE and when it is blank the value = FALSE.

ie. Cell A1 has a checkbox and I want to reference cell A1 in cell B2.
So if A1 is checked and the value is true than B2 would change to 100
and if it is false it would stay at 200.

Thanks in advance.
 

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

True/False Checkbox 1
Code to display a true or false value in the cell containing a check box 1
Set value of checkbox on userform without triggering Click event 7
Can Checkboxes trigger the Worksheet_Change code? 3
Question about checkboxes 10
Auto Assign Checkboxes in Excel 2007 2
offset merged cell 10
Excel In Excel how can I block the contenent of a cell? 0

Top