Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub Data_Validation()
- ' Check if all data has been entered on the userform
- If ARLArea = False And KNBArea = False And LSQArea = False And RSQArea = False And RevenueControlInspectors = False And SpecialRequirementTeam = False Then
- MsgBox "Select Area!", vbInformation, ("Area")
- ARLArea.SetFocus
- Exit Sub
- End If
- If EmployeeNo1 = "" Then
- MsgBox "Enter Employee Number!", vbInformation, ("Employee Number")
- EmployeeNo1.SetFocus
- Exit Sub
- End If
- If FirstName1 = "" Then
- MsgBox "Enter First Name!", vbInformation, ("First Name")
- FirstName1.SetFocus
- Exit Sub
- End If
- If LastName1 = "" Then
- MsgBox "Enter Last Name!", vbInformation, ("Last Name")
- LastName1.SetFocus
- Exit Sub
- End If
- If CSA2 = False And CSA1 = False And CSS2 = False And CSS1 = False And CSM2 = False And CSM1 = False And AM = False And RCI = False And SRT = False Then
- MsgBox "Select Grade!", vbInformation, ("Grade")
- CSA2.SetFocus
- Exit Sub
- End If
- BlnVal = 1
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement