Make two Option Buttons the paste this code in the worksheet code module for the worksheet that has the Option Buttons. You can right click on the sheet tab and select View Code to get to the appropriate code window.
Option Explicit
Private Sub OptionButton1_Click()
If Me.OptionButton1.Value = True Then
MsgBox "You presses OptionButton1"
Else
MsgBox "You presses OptionButton2"
End If
End Sub
Private Sub OptionButton2_Click()
If Me.OptionButton1.Value = True Then
MsgBox "You presses OptionButton1"
Else
MsgBox "You presses OptionButton2"
End If
End Sub