radio buttons to equal values
 

I have an evaulation form that I want to have the user choose one of four
answers (like meets expectations, exceeds expectations, etc.) with a
numerical result on the right side of the line. I would like to add radio
buttons so if for example "exceeds expectations" is clicked then the line
registers a 20, and if "meet expectations" is met then 10 points are given,
etc.
How can I add the radio button assigned to a value?
--
Louis

radio buttons to equal values
 

Using the buttons from the Control Toolbox, right click the button and put
code like the below sample in the click macro:

If OptionButton1.Value = True then
Range("A1") = Range("A1") + 20
End If

The above code assumes that one range will be used to accumulate the total
score.
If not, just eliminate the second Range("A1") + and use a different range
for each question.

"Louis" wrote:

I have an evaulation form that I want to have the user choose one of four
answers (like meets expectations, exceeds expectations, etc.) with a
numerical result on the right side of the line. I would like to add radio
buttons so if for example "exceeds expectations" is clicked then the line
registers a 20, and if "meet expectations" is met then 10 points are given,
etc.
How can I add the radio button assigned to a value?
--
Louis