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

It appears you are putting up an error message if the toggle button is true
and either textbox is empty. That seems to correspond with what you want to
do. What is the problem?

--
Regards,
Tom Ogilvy

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

My code is



If S74FailQualityFailToggleButton.Value = True And
Len(Section74ComboBox.Text) < 1 Or _
Len(QualityComboBox.Text) < 1 Then
MsgBox ("YOU MUST ENTER A REASON FOR THE SECTION 74 / QUALITY
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 inform
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/