OptionButton problem

[Patrick Simonds]

I am trying to include the code below in the CommandButton1 click routine so
that 1 of the three OptionButtons is selected before the macro continues.
There are 3 OptionButtons and all three are assigned to GroupName Status.
But even if I have an OptionButton selected the macro proceeds to Finished,
and I am not sure why.


If OptionButton1.Value = False Then
GoTo Finished
ElseIf OptionButton2.Value = False Then
GoTo Finished
ElseIf OptionButton3.Value = False Then
GoTo Finished

End If

 

[Tom Ogilvy]

If OptionButton1.Value = false And _
OptionButton2.Value = false And _
OptionButton3.Value = False Then
GoTo Finished

End If