Syntax Highlighting

While typing VBA code, it is automatically checked for correct syntax (another advance over Excel 4). It is also color-coded—Making it easy to see those lines commented out a week ago are still comments and need to be changed back. To control the colors VBA assigns to code open the Tools/Options/Module Format dialog. This dialog can also change the font and size of the text.