Check Boxes in formulas

[mark hansen]

I have started using check boxes more and more now and I have been using the Linked Cell in the checkbox properties. In cell formulas, I reference the linked cell as either a TRUE or FALSE to determine what I want. (Mostly if text is suppose to display or not)

This is working well, but a bit messy.

I was wondering if I can reference the checkbox directly in a formula. This would help keep my spreadsheet a bit cleaner and I wouldn't have to have the cells with True false all over the place - if it can be done.

Just wanted to make sure I wasn't overlooking something obvious.

Thanks,
Mark

 

[T. Valko]

I have started using check boxes more and more now and I have been using the Linked Cell in the checkbox properties. In cell formulas, I reference the linked cell as either a TRUE or FALSE to determine what I want. (Mostly if text is suppose to display or not)

This is working well, but a bit messy.

I was wondering if I can reference the checkbox directly in a formula. This would help keep my spreadsheet a bit cleaner and I wouldn't have to have the cells with True false all over the place - if it can be done.

Just wanted to make sure I wasn't overlooking something obvious.

Thanks,
Mark

No, you can't directly reference a ckbox in a formula.

You can hide all those TRUE and FALSE by using conditional formatting if you don't want to see them.

 

[jeffreybrown]

Maybe as an option. Scrap the checkboxes and go with...

http://www.mrexcel.com/forum/showpost.php?p=2232805&postcount=5

 

[mikerickson]

To tidy up the screen, you could position the checkbox over the cell that it is linked to.

Alternatly, you could like all of your checkboxes to cells on a hidden worksheet.
(If you give those linked cells name like CheckBox1 CheckBox2, etc. using the names in formulas would make editing easier.)

 

[mark hansen]

OK, thanks... I like the idea of putting the linked cell under the check box. I also think putting the linked cells on a separate sheet is nice too. Un hidden during development and hidden when you are done. This would help with labeling to keep things straight.

Jeffery I use something like that code a lot in certain curcumstances and it works well.

Thanks for your quick responses.

Mark