Hi there

I'm not really sure what you are asking to do but if you put the code
below into the module for your worksheet it might give you a better
idea of the code.

Private Sub OptionButton1_Click()

If OptionButton1 = True Then

MsgBox [A25].Value

End If

End Sub

Private Sub OptionButton2_Click()

If OptionButton2 = True Then

MsgBox [A26].Value

End If

End Sub

Private Sub OptionButton3_Click()

If OptionButton3 = True Then

MsgBox [A27].Value

End If

End Sub

hope this helps

Steve