A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
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.
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.
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.
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.
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.
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.
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.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide