MsgBox line break

[Guest]

I would like to add a line break to a message box. The VBA help file for
MsgBox says you can use a carriage return character (CHR(13)) or linefeed
character (Chr(10)), but I can't figure out how to use them.

What I have is something like this:

MsgBox("This is line #1"Chr(13)"This is line #2")

but this give me an error "Compile error: Syntax error"

Thanks for any help,
~ Horatio

 

[Guest]

Thank you.

MsgBox "This is line #1" & vblf & "This is line #2"
or
MsgBox "This is line #1" & chr(10) & "This is line #2"
or
MsgBox "This is line #1" & vbnewline & "This is line #2"