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).
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
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.
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!