Understanding automation : How is automation coding structured? : Ending lines |
In VBA, each statement must exist on its own line, but no special character is required to denote the end of each line. (In contrast, many other programming languages use a semicolon to separate individual statements.)
To break a long VBA statement over two or more lines, each of the lines (other than the last line) must end with an underscore ( _
) preceded by at least one space:
newString = fooFunction ("This is a string", _ |
5, 10, 2) |
You can combine several statements in a single VBA line by separating them with colons:
a = 1 : b = 2 : c = a + b |
• |
A VBA line cannot end with a colon. VBA lines that end with a colon are labels that are used by the Goto
statement.
|
Copyright 2013 Corel Corporation. All rights reserved.