Thread: Option Buttons
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Option Buttons

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

--

HTH

RP

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