If option button not selected
 

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

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

If option button not selected
 

Thanks very much, Bob

--
Hywe
-----------------------------------------------------------------------
Hywel's Profile: http://www.excelforum.com/member.php...fo&userid=1482
View this thread: http://www.excelforum.com/showthread.php?threadid=48280