Auto Syntax Check

As you type your code it is automatically checked for syntax errors.
If any syntax errors are found then you are alerted with a pop up message box.
For example any misspelled keywords or missing separators will be identified.

microsoft excel docs

When this option is switched On.

Typing Public Sob Test and pressing Enter will display a pop up dialog box.

Public Sob Test 
microsoft excel docs

Also changing a valid line to an invalid line will also display a pop up dialog box.

Public Sub Test 
Public Sob Test

When to Turn this Off

At some point you may start to find these pop ups frustrating in which case it is time to turn this option off.
Don't worry though your syntax errors will still be identified in a different colour, so they are easy to spot.

microsoft excel docs

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext