How do you line wrap code in VBA?

[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.

 

[Nick Coe \(UK\)]

Underscore _

There are limitations though IIRC. Look up continuation or
line continuation character in the help.

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.mrcomputersltd.com/ Repairs Upgrades

In James D. typed:

 

[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);"