Entering VBA Code

When you type VBA code in a module, it s good programming practice to use TAB to indent related lines for easier reading. 

As you type your VBA code. Excel checks each line for errors. A line that contains one or more errors will be displayed in red, or another color if previously specified. Variables usually appear in black. Other colors are also used comments (see later) are usually green and VBA keywords (Function, Range, etc.) usually appear in blue. 

You can enter numbers in E format but they will automatically be converted to floating point. You can t enter numbers as percentages the percent symbol has another meaning in VBA (see VBA Data Formats later in this chapter). 

If you type a long VBA expression, it will not wrap to the next line but wiU simply disappear off the screen. You will have to insert a line-continuation character (a space followed by the underscore character followed by RETURN) to cause a line break in a line of VBA code, as in the following example  

The line-continuation character can t be used within a string. 

---