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
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: > 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
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)
