If information is missing from the sheet, I'd like a message box to appear

[ghostbroker2]

[FONT=&quot]Dropbox link;[/FONT]
https://www.dropbox.com/s/vi2zpdo86e...T%29.xlsm?dl=0

[FONT=&quot]When the operator presses "Submit", I'd like Excel to verify completion of the form. [/FONT]
[FONT=&quot]If required information is missing, I'd like a message box to appear, alerting the operator.[/FONT]

[FONT=&quot]A simple message box stating that "There is required information that is missing." will suffice.[/FONT]
[FONT=&quot]However if we can then make it highlight the empty cells with missing information, that will count as the touchdown and the 2 point conversion.[/FONT]

[FONT=&quot]All of that being said, there are cells where info is not required (is optional), I filled them yellow.[/FONT]

[FONT=&quot]I want to thank the members of this forum, as you guys wrote 2 of the macros that are in use on this sheet, and have helped me perfect the others.[/FONT]

[FONT=&quot]Thanks again guys![/FONT]