If you want to to make sure the user has entered all the required fields before saving and closing Excel. This is where this macro comes in.

Conditionally executes a group of statements, depending on the value of an expression. Syntax If condition Then [ statements ] [ Else […]