Thread: If option button not selected
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
  
Posts: 11,272
Default If option button not selected
With ActiveSheet
If Not .OptionButtons("Option Button 1").Value And _
Not .OptionButtons("Option Button 2") Then
MsgBox "None set"
End If
End With


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hywel" wrote in
message ...

How do I get a warning message to appear if one of two option buttons
within a frame are not selected?

I have tried with optionbutton.value = True but I can't get this to
work.
Many thanks,
Hywel
Manchester UK


--
Hywel
------------------------------------------------------------------------
Hywel's Profile:
http://www.excelforum.com/member.php...o&userid=14824
View this thread: http://www.excelforum.com/showthread...hreadid=482809



Reply With QuoteReply With Quote