option button problem

[THIRDCOAST]

I have a spread sheet that I want to place an "option button" in a cell, so
that when that "option button" is clicked it will give me a number in another
cell. Can anyone give me an easy version of how to do this? Thank you in
advance for your assistance.

 

[Incidental]

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