Check your VBA code for errors

Check your VBA code for errors: Visual Basic includes a syntax-checking feature that checks each statement as you enter it for syntax errors, such as a misspelled keyword or missing separator, and alerts you if there are errors. It also translates the code to an internal form if the syntax is correct, which speeds the transition to run time. This feature is turned on when you first start, but you can turn it off if you prefer to write code without being alerted to errors as they occur. To enable syntax checking, click Options in the Tools menu. Select the Editor tab, then the ‘Auto Syntax Check’ check box. After that, click OK.