Radio Buttons

Guest · Posted: Mon Nov 05, 2007 11:24 am Post subject: Radio Buttons

Hi there,

Please could some one help me with some code to say if this set of
radio of buttons is not selected then please do so.

thanks

Matt

Google · Sponsor

Greg Maxey · Guest

Assuming these option buttons are in a Userform then code something like
this in in your command button code:
Private Sub CommandButton1_Click()
Select Case True
Case Me.OptionButton1
Case Me.OptionButton2
Case Me.OptionButton3
Case Else
MsgBox "Please select an option button"
Exit Sub
End Select
'Rest of your command button code
End Sub

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

matthew.rodwell@luptonfawcett.com wrote:

Guest · Posted: Mon Nov 05, 2007 3:52 pm Post subject: Re: Radio Buttons

Thanks for this worked perfectly thankyou...

my second part is i have written this code before but i would also
like it to pop up if this hasn't been ticked or data had not been
written in to the box..
Private Sub optu3m_change()
txtover3m.Enabled = False = optu3m
Label50.Enabled = False = optu3m
End Sub

Above is the code i mean for the tick box so it desables the text box
but i what a messafe to pop up if neither these are used.

..i would also then like it to go back to the place in the screed
design where it was...(say i have 3 pages and this question was on
page 2 but obvouisly u finish on page 3)