Break long line of code (2003)

Topic

New Reply

HI all. How do I break a long line of code so I don’t have to scroll left and right to read it?

Thanks!

Reply | Quote

Replies

Enter a space and an underscore character:

‘Very long line of code part 1 _
Remainder of very long line (part 2)

Reply | Quote

Insert a space and an underscore then press Enter:

MsgBox "Do you want to continue?", _
vbQuestion + vbYesNo

or

Range("A4").Value = Range("A1").Value + _
Range("A2").Value

Indenting the second line (and subsequent ones) is not obligatory, but it makes the code easier to read.

Reply | Quote

Many thanks to both!

Reply | Quote