Hello all
I have a small problem. I am working in word on a form for users to fill in , almost like a 1 to 3 kind of questionaire, where they select only one option. Unfortunately I need to identify which one has been checked in order to give me the total for the selections i.e. overall opinion.
There are 3 options on each row and each row is named Row1, Row2, Row3 etc. I had orginally tried appending a variable in order to count through certain option buttons e.g.
However this did not work. How can I solve this, someone mentioned control arrays, but I dont know how to use them/set them up so I cant loop through them. Also when I have selected the right control how do I identify which one it is in order to add the answers for a total.
Many thanks in advance.
Neil
I have a small problem. I am working in word on a form for users to fill in , almost like a 1 to 3 kind of questionaire, where they select only one option. Unfortunately I need to identify which one has been checked in order to give me the total for the selections i.e. overall opinion.
There are 3 options on each row and each row is named Row1, Row2, Row3 etc. I had orginally tried appending a variable in order to count through certain option buttons e.g.
Code:
Public Sub Done_Click()
For j = 1 To 3 ' boxes
If SCheckH & j.Value = True Then MsgBox "Hello" Else MsgBox "No"
Next j
End Sub
Many thanks in advance.
Neil