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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Thanks very much, Bob.