Microsoft Office Tutorials and References
In Depth Information
Each line can be as long as you like; the VBA module window scrolls to the left when you reach
the right side. For lengthy lines, you may want to use VBA’s line continuation sequence: a space
followed by an underscore (_). For example:
Sub LongLine()
SummedValue = _
Worksheets(“Sheet1”).Range(“A1”).Value + _
End Sub
When you record macros, Excel often uses underscores to break long statements into multiple
After you enter an instruction, VBA performs the following actions to improve readability:
It inserts spaces between operators. If you enter Ans=1+2 (without spaces), for example,
VBA converts it to
Ans = 1 + 2
It adjusts the case of the letters for keywords, properties, and methods. If you enter the
following text: Result=activesheet.range(“a1”).value=12
VBA converts it to
Result = ActiveSheet.Range(“a1”).Value = 12
Notice that text within quotation marks (in this case, “a1” ) isn’t changed.
Because VBA variable names aren’t case-sensitive, the interpreter by default adjusts the
names of all variables with the same letters so that their case matches the case of letters
that you most recently typed. For example, if you first specify a variable as myvalue (all
lowercase) and then enter the variable as MyValue (mixed case), VBA changes all other
occurrences of the variable to MyValue . An exception occurs if you declare the variable
with Dim or a similar statement; in this case, the variable name always appears as it was
VBA scans the instruction for syntax errors. If VBA finds an error, it changes the color of
the line and might display a message describing the problem. Choose the Visual Basic
Editor Tools➜Options command to display the Options dialog box, where you control the
error color (use the Editor Format tab) and whether the error message is displayed (use
the Auto Syntax Check option in the Editor tab).
A comment is descriptive text embedded within your code and ignored by VBA. It’s a good idea
to use comments liberally to describe what you’re doing because an instruction’s purpose isn’t
always obvious.
Search JabSto ::

Custom Search