How do I add a checkbox to a row in excel?

Question

I would like to add a checkbox at the end of each row and then evaluate if the checkbox is checked or not in another cell. Is there an easy way to do this without a macro, since I don't know any VBA. If this is only possible with a macro, what alternatives do I have, or did somebody already do this and can give me his/her macro.

Answer 1

Yes, you can do this. I will demonstrate using Excel 2007.

Using fonts:
I went to Wingdings and added a Checkmark in A1 (character code 0252). In regular text, this is ü. Then in cell B1 I put this formula:

=if(A1="ü", 1, 0)

If A1 has a check in it, then B1 will have a 1. If A1 does not have a check, then B1 will have a 0.

Using form controls:

• Show the developer tab in the Ribbon.
• Insert --> Form Controls: CheckBox
• Draw the checkbox where you want it.
• select the checkbox, click Properties in the Menu
• For Cell link, enter the address of the cell you want to link this checkbox to.

Now when you check the box, the cell will read TRUE. If it's unchecked, it will read FALSE. Also, if you enter anything other than a zero in the cell, the box will be checked.