How to add a checkbox for a row in Excel?

How to add a checkbox for a row in Excel? "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? If this is possible only with using a macro, what alternatives do I have, or did somebody already do this and can give me his/her macro?"
Asked by: Guest \| Views: 336

Total answers/comments: 1

Comments display order:

bert [Entry]

"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 is 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."