If statement question!

[RustyNail]

Hello,

if I do this:

Please Login or Register  to view this content.

The compiler accepts it.

But if I do this:

Please Login or Register  to view this content.

Then the compiler complains by showing the latter lines in red!!!

Sometimes I have several test conditions that are part of the same "if" statement!!!
Personally I tend to want to compact the length of the "if" statement by layering its conditions
one under the other for better view... its a personal thing I guess!

So my question, is, in VBA, is it at all possible to do the "if" statement spread out on a few lines as shown in the latter example?

Thanks for your help
rn

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Arkadi]

What TMS said... the key is that when you break a line up like that, you need an underscore "_" to tell VBA what is happening.