Remove Auto Syntax Popup – VBA Excel Coding Tips

We all love Excel and looks like there is no need any introduction for what is Visual Basic programming. As we all know VB programming allows us to automate tasks and we can do a lot more in Excel with it. But, have you observed the pop-up shown when you make any syntax error while doing Visual Basic programming? It somewhat made us feel comfortable and most of us do not like it. If you are one among them and want to remove auto syntax popup in Visual Basic programming, then Excel MVP Jordan Goldmeier unfolds the tip showing to remove auto syntax popup.

Remove Auto Syntax Popup

In order to open Visual Basic Editor, you need to have ‘Developer’ tab enabled in your Spreadsheet. So, let us see how to enable ‘Developer’ tab and other steps to remove auto syntax popup.

1 – Enable Developer Tab

Once you open the Excel Spreadsheet, click on ‘File’ and select ‘Options’. In ‘Excel Options’ dialog box, click on ‘Customize Ribbon’ on the left side. Check the option ‘Developer’ on the right side and click ‘Ok’. This would show the ‘Developer’ tab in your Excel Spreadsheet.

2 – Open the Visual Basic Editor

To open Visual Basic editor, click on ‘Visual Basic’ icon under ‘Developer’ tab. This would open the ‘Microsoft Visual Basic for Applications’ window where you can start writing the Visual Basic programs.


3 – Auto Syntax Popup

When you make any syntax error, then it would show the dialog box with ‘Compile error:’ message. It also shows the line with syntax error with the red color. Actually, whenever you hit enter, it would auto check the syntax and if there is any error it throws the pop up as shown.


4 – Remove Auto Syntax Popup

If you do not want to have the auto syntax checks and wants to remove auto syntax popup, then click on ‘Tools’ and then click on ‘Options’


Now, in ‘Options’ dialog box, uncheck the option ‘Auto Syntax Check’ and click on “Ok” button.



From now on, when there is any syntax error, then it would be shown in red colored syntax and there would be no more auto syntax popup.

What’s next?

Jordan has introduced us the very good and useful tip. Give it a try and let us know your opinion or suggestion on it. If you have anything to add, please do share with us through comments.


You may also like

December 20, 2013

100+ Best Excel Resources And Websites

August 6, 2019

How to Create a Relative File Path in Power Query

April 9, 2011

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

September 17, 2012

The Excel Rollover Mini FAQ

February 17, 2014

It’s time to say “Goodbye,” to Hungarian Notation
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.