Where is the value of 3? Anyway, to answer your question... I presume these
OptionButtons are grouped in some way (otherwise your user would be able to
select more than one at a time). Because only one OptionButton can be
selected at a time, just multiply each OptionButton's value (0 if not
selected, 1 if select) by its value and sum them up... the value returned
will be the OptionButton's value. Let's assume the OptionButton's are named
this way...

Strongly Agree button --- Opt1
Agree button ------------ Opt2
Disagree button --------- Opt3
Strongly Disagree ------- Opt4

Then the value the user selected can be found like this...

UsersValue = 5 * Opt1.Value + 4 * Opt2.Value + 2 * Opt3.Value + Opt4.Value

Remember... only one of the Opt{n}.Values will be 1 and the rest will be 0.

Rick


"trainer07" wrote in message
...
I am building an evaluation sheet in Excel and want to know how I can give
a
numerical value to a radio button. For example, one of the question
reads,
"The trainer spoke clearly". and the option buttons read: Stronly Agree,
Agree, Disagree, Strongly Disagree. I want to give the following values
to
each answer option: Strongly Agree = 5, Agree = 4, Disagree = 2, Strongly
Disagree = 1 . My ultimate goal is to find the average score for all the
questions. Any assistance would be appreciated.
Thanks!