THe Resume line character ?

ontheDB · #1 (**permalink**) 01-13-04, 17:19

Hi,

In VBA programming,

how do u spread one line of code onto multiple lines.

e.g.

if ( (var1 = 0) AND (var2= 1) ) then
.
.
.

how would i split that up to ?

if ( (var1 = 0) AND
(var2 = 1) then

thanks

Xl-Dennis · #2 (**permalink**) 01-14-04, 05:39

Hi,

Code:

if ( (var1 = 0) AND _
    (var2= 1) ) AND _
end if

For text like "XL-Dennis prefer to work with MySQL" then use:

Code:

Dim stMsg as String

stMsg = "XL-Dennis prefer " _
            & "work with MySQL"

HTH
Dennis

Internet Services

Web Development

Digital Marketing

Consumer Tech