OptionButton problem

  • Thread starter Patrick Simonds
  • Start date
P

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
 
T

Tom Ogilvy

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

End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Placing Optionbutton Value 3
How to reference optionbutton within frame 0
TextBox_Change() problem 3
Change OptionButton true/false status on all sheets 10
slow macto 2
WorkSheet Change Event - Need Help With Coding Syntax 2
How to referance a GroupName 3
TextBox Change/Exit problem 3

Top