Code to continue code on next line

[Pamela]

I have a pretty long piece of code that I'd like to space out over multiple
lines for easier reading and future handling and I know I've seen a special

 

[John W. Vinson]

I have a pretty long piece of code that I'd like to space out over multiple
lines for easier reading and future handling and I know I've seen a special

The line continuation signal is a blank followed by an underscore at the end
of the line:

FirstLine Of Your Code _
and then the second

 

[Pamela]

Thanks, John. That's what I needed. In doing that though, I don't see that
the system is allowing me to use in between the description symbol '. I'm
sure there's a technical name for it but where you use the apostrophe mark
and then it disregards that which follows (turning it green). I'm really
hoping to utilize that function so that I can later go in and easily find
aspects of it to change or fix anything needed. How can I use these two
features together??

 

[John W. Vinson]

Thanks, John. That's what I needed. In doing that though, I don't see that
the system is allowing me to use in between the description symbol '. I'm
sure there's a technical name for it but where you use the apostrophe mark
and then it disregards that which follows (turning it green). I'm really
hoping to utilize that function so that I can later go in and easily find
aspects of it to change or fix anything needed. How can I use these two
features together??

As far as I know, you can't - just as you cannot embed a comment block inside
a single line statement.

I remember in PL/I you could use

X = Y + /* This just adds the two values */ Z

but you don't have that liberty in VBA to my knowledge! Anyone else have a
suggestion?