I have rows that each contain 2 radio buttons one for yes and one for no (they are grouped through from control) I would like to assign a value to both yes and no to appear in another column. For example, If a user selects yes, this is = to 1, if they select No, this is equal to 0. I want this result to appear in the next column.
Don't know exactly if this is what you want but you can insert two Option buttons into a Group Box. When user selects one of the Option butons the linked cell will have the value of 1 and when the other is selected the linked cell will have the value of 2.