Option Buttons

[Dayton]

How do I make sure that one of my two buttons have been selected before the
rest of my code exectues.


If OptionButton1 "NOT SELECTED" and OptionButton2 "NOT SELECTED" then
MsgBox "Make Selction".....
Else
'Execute statements

End If

 

[Guest]

If OptionButton1 = True Or OptionButton2 = True Then
'Execute statements
Else
MsgBox "Make a selection"
End If

 

[Guest]

Dayton,

If this is on a form, disable the comand button that executes "the rest of
your code". When an option button is clicked, enable the command button.
Please note, the command button may lose it's "Default" status as a result.

Dale Preuss

 

[Bob Phillips]

If Not OptionButton1.Value and Not OptionButton2.Value then
MsgBox "Make Selction".....
Else
'Execute statements
End If