I am using a Toggle button and two Textboxes and i need to error tra
to make sure that there is text in the Textbox or i want to generate a
error and End Sub.

My code is



If S74FailQualityFailToggleButton.Value = True An
Len(Section74ComboBox.Text) < 1 Or _
Len(QualityComboBox.Text) < 1 Then
MsgBox ("YOU MUST ENTER A REASON FOR THE SECTION 74 / QUALIT
FAILURE !!"), vbCritical, "ERROR CODE 012"
Exit Sub
Else
End If


What i was trying to do was say if the togglebutton is pressed (True)
and there is text in the two textboxes then continue othrwise infor
the user why there is an error.


Can anyone suggest a fix for this problem.

Thanks in advance

--
Message posted from http://www.ExcelForum.com