Cell Links for Option Boxes

[LauraC]

I am using XL97, I have 4 Group Boxes each with 4 Option buttons/boxes.

What I want to do is within one group box (i.e. Question 1) link all the
options (answers- i.e. High, Med, Low, None) to the same cell link, MS Help
makes it sounds as though it would then display it in number format
(dependant on option selected) and that would be ideal as I want to plot a
graph from the results.

Can anyone please offer suggestions, if I select the same cell for the four
options within one group in properties it just doesn't work. It'll only work
with having four seperate cell links displaying true or false, and I'd rather
not have to start using IF statements.

Any ideas anyone please.

Sorry for posting twice I didn't mean to put it in programming initially!

 

[Jason Morin]

Why not use a formula? Say your 4 option buttons are
linked to A1,A2,A3, and A4. In another cell you could
return a value dependent upon which cell is TRUE. Let's
say if A1 = TRUE, you want a 10, A2 = TRUE --> 9, A3 -->
8, and A4 --> 7.

=CHOOSE(MATCH(TRUE,A1:A4,0),10,9,8,7)

HTH
Jason
Atlanta, GA