option button problem
 

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.

option button problem
 

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