Radio Buttons

[matthew.rodwell]

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

 

[Greg Maxey]

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

 

[matthew.rodwell]

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)