How do you line wrap code in VBA?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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);"
 
Back
Top