In VBE, choose Tools | Options from the menu bar to display the Options dialog box. In the Editor tab, make sure all the check boxes are ticked. After sometimes writing VBA code and knowing the programming syntax, you may want to unselect the Auto Syntax Check option.
The Auto List Members and Auto Quick Info options are particular useful. While you type the name of an object followed by a dot (also known as a period) in the code window and in the Immediate window, Auto List Members allows a list of members for that object to be displayed automatically. You can then use the up- and down-arrow keys and the Tab key to select an item from the list.
If you type the name of a function, property, or method followed by an opening parenthesis, Auto Quick Info allows the information about the arguments available for the function, property, or method to be displayed automatically.
In the Editor Format tab, you can see the default colors for text in the code window. The table below shows some of them.
| Text in the code window | Default color |
| Normal code | Black |
| Keywords | Blue |
| Comments | Green |
| Syntax errors | Red |
All other settings in VBE are just right by default.
Dissecting Excel VBA 