How do you line wrap code in VBA?

J

James D.

I have a rather large calculation being performed and it scrolls quite far to
the right. I want to modify the format of the calc so that I can break it up
to continue on the next line so it will all be visible. I know how to do
this in other languages, but not in VBA. Any Ideas would be great.

Thx.

James D.
 
A

Allen Browne

Use the underscore as the line continuation character.

Cannot be inside a string, so you may end up closing the string, and
concatenating the rest after the line break:
strSql = "SELECT * FROM Table1 " & _
"WHERE (False);"
 
Top