Slight variation on above
![]()
Option Explicit Sub VALIDATEINPUT() Dim Nm As Name For Each Nm In Names Select Case Nm.Name Case "EMP": If Range("EMP") = "" Then MsgBox ("You must enter an employee number at the top") Case "RES" If Range("RES") = "" Then MsgBox ("You must select a reason for the change request") ElseIf Range("RES") = "Other - Please specify" Then If Range("RESO") = "" Then MsgBox ("You must enter a reason in the 'other reason' box") End If 'etc End Select Next Nm
Bookmarks