The following code is very simple. All I need to do is figure out how get the
result of the userform entry from the click event. I apologize if seems to
easy but I have trouble with userforms and menus getting user data.
Thanks for Your Help

Sub test()
UserForm1.show
If Me.OptionButton1 = "True" Then
Debug.Print "Option One has been Selected"
Else
Debug.Print "This has failed miserably"
End If
End Sub


Private Sub OptionButton1_Click()
Dim Sel As String
Unload Me
MsgBox ("You Select Buton 1")
Sel = Me.OptionButton1
End Sub

Private Sub OptionButton2_Click()
Unload Me
MsgBox ("You Select Buton 2")
Unload Me
End Sub

Private Sub OptionButton3_Click()
MsgBox ("You Select Buton 3")
Unload Me
End Sub