Turn Off Annoying Error Alerts in Visual Basic Editor (VBE)

Turn Off Excel VBA VBE Compile Error Alerts

What's The Problem?

When I first started coding in the Visual Basic Editor (VBE) I always got so annoyed with the message box alerts that would pop up every time I didn’t use proper syntax.  This caused me to get distracted since every time I didn't type something in properly I would get an error alert and have to click the OK button (usually occurred every other minute).

Visual Basic Editor Compile Error Dialog

Being new to using the Visual Basic Editor, I thought this was just normal and I had to live with the annoying pop-ups.  After I got more comfortable with the editor I started playing around with the options and stumbled upon a setting that I am so thankful exists!  This setting allowed me to turn off the annoying syntax error message alerts and I have not seen one since!

How To Get Rid Of Them

In the VB Editor (shortcut: Alt + F11) go to Tools > Options

Remove VBE Error Alerts in Microsoft Excel Writing Macros

In the Options dialog box make sure that Auto Syntax Check is NOT checked in the Code Settings section.  This turns off the error messages while still coloring incorrectly syntaxed code red.

Remove VBA Error Alerts Auto Syntax Check Excel VBA Macros

Hit the OK button and you should be error message free from now on!

My Question To You!

So I'm curious, was I just naive or did it take you a long time to figure out how to rid your life of VBA Error Alerts? Leave a comment below and let me know how long it took you!