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.
Yes, you can do this. I will demonstrate using Excel 2007.
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:
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.