spacebar compile error

[stevengoh]

If c.Value Like "*steven*" Or c.Value Like "*hello*" Or c.Value Like "*goh*"

The above VB is working perfectly, but if I spacebar..

If c.Value Like "*steven*"
Or c.Value Like "*hello*"
Or c.Value Like "*goh*"

compile error..
Is there way to have the spacebar so that it is neater..
Thank

 

[Colin Legg]

In VBA you need to use a line contination character, being a space followed by an underscore

If c.Value Like "*steven*" _
    Or c.Value Like "*hello*" _
    Or c.Value Like "*goh*"

 

[VoG]

You need to use the continuation character _

If c.Value Like "*steven*" _
Or c.Value Like "*hello*" _
Or c.Value Like "*goh*" Then

 

[stevengoh]

thk