OptionButton problem
 

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

End If



--
Regards,
Tom Ogilvy


"Patrick Simonds" wrote in message
...
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