Hi everyone,



I'm trying to create an evaluation form in Word, and have run up against a coding issue that I hope someone here can help with. Here goes: I have a table, and within that table there are six checkboxes, each in a separate cell. We want these to be mutually exclusive for reasons of scoring. A seventh cell should display a score based on which checkbox is selected. This setup occurs for multiple criteria, then at the bottom the combined criteria scores are tallied.

So, first things first. I found code on Microsoft's web site that works perfectly for making the checkboxes mutually exclusive in sets, so I'm OK with that. Further, I know how to create a SUM field to tally the scores once they are in place. It's getting a score to show based on the box selected that has me stumped.

I've searched all over the web and spent several days trying various IF/THEN formulas and macros, but haven't gotten any to work. In short, what I want is this: a user checks box 6, and the score "6" appears in the seventh cell. If they change and mark box 5, the score changes to 5, and so on.

I'm sure I'm missing some very easy, but since I'm a noob at VBA, I come hat in hand to ask the experts. Any ideas how I can connect the check boxes to a score for easy calculation? Any help and assistance is appreciated!

UPDATE: Here is one code I found, but I receive a "424" error when I attempt to run it.
Sub CheckBox1_Change()
If CheckBox1.Value = True Then
TextBox1.Text = "Checked!"
Else
TextBox1.Text = "Unchecked."
End If
End Sub