Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 5 down vote accepted

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.

share|improve this answer
    
+1 This is the way I do it. Wingdings are your friends! –  Hondalex Sep 17 '09 at 14:34
    
Using the same method, you could use the letter X as a checkmark. Your if statement would read =if(A1="x","There's an X in A1", "No X in A1") - This works whether the x is capitalized or not. –  Jared Harley Sep 17 '09 at 15:12

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.