Advertisement
popoytanke

check macro

May 13th, 2024
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. Sub Check()
  2.  
  3. If Range("F4") = "" Then
  4. MsgBox "Please enter Employee number."
  5. Range("F4").Select
  6. ElseIf Range("F6") = "" Then
  7. MsgBox "Please enter Employee name."
  8. Range("F6").Select
  9. ElseIf Range("F8") = "" Then
  10. MsgBox "Please select one."
  11. Range("F8").Select
  12. ElseIf Range("F10") = "" Then
  13. MsgBox "Please select one."
  14. Range("F10").Select
  15. ElseIf Range("F12") = "" Then
  16. MsgBox "Please select one."
  17. Range("F12").Select
  18. ElseIf Range("F14") = "" Then
  19. MsgBox "Please enter MGP #."
  20. Range("F14").Select
  21. ElseIf Range("F16") = "" Then
  22. MsgBox "Please select one."
  23. Range("F16").Select
  24. ElseIf Range("F18") = "" Then
  25. MsgBox "Please enter NA if not available."
  26. Range("F18").Select
  27. ElseIf Range("Q4") = "" Then
  28. MsgBox "Please enter serial number."
  29. Range("Q4").Select
  30. ElseIf Range("Q6") = "" Then
  31. MsgBox "Please select one."
  32. Range("Q6").Select
  33. ElseIf Range("Q8") = "" Then
  34. MsgBox "Please select one."
  35. Range("Q8").Select
  36. ElseIf Range("Q10") = "" Then
  37. MsgBox "Please enter serial number."
  38. Range("Q10").Select
  39. ElseIf Range("Q12") = "" Then
  40. MsgBox "Please enter NA if not available."
  41. Range("Q12").Select
  42. ElseIf Range("Q14") = "" Then
  43. MsgBox "Please enter NA if not available."
  44. Range("Q14").Select
  45. ElseIf Range("Q16") = "" Then
  46. MsgBox "Please select one."
  47. Range("Q16").Select
  48. ElseIf Range("Q18") = "" Then
  49. MsgBox "Please select one."
  50. Range("Q18").Select
  51.  
  52. Else
  53.  
  54. Call Submit
  55.  
  56. End If
  57. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement