Check box (control form) checked or not - must be a simple way to test if box checked

**JET2011** · 12-19-2012, 09:27 PM

How can I have a simple test in cell B1 to see if a user checked a check box in cell A1?

Have looked around much, see only complex solutions and I'm not a programmer.

Thanks

J

**benishiryo** · 12-19-2012, 09:48 PM

hi J, welcome to the forum. right-click on the check box and you should see Form Control. go to the tab "Control" -> Cell Link:
B1

TRUE indicates a check, FALSE indicates otherwise. if you prefer to have something else shown instead, put the cell link somewhere else. maybe Z1. then do an IF formula in B1:
=IF(Z1,"Checked","Not Checked")

**JET2011** · 12-19-2012, 11:23 PM

Thanks for the assist!

Check box (control form) checked or not - must be a simple way to test if box checked

LinkBack

Thread Tools

Rate This Thread

Display

Check box (control form) checked or not - must be a simple way to test if box checked

Re: Check box (control form) checked or not - must be a simple way to test if box checked

Re: Check box (control form) checked or not - must be a simple way to test if box checked

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions