VBA msgbox function

[LesLdh]

I want to have a msgbox prompt that has two lines of text, eg:

MsgBox("This is the first line
this is the second line")

I understand that I have to use a carriage return character, but can't seem
to get the syntax right. Can anybody help?

Les.

[Nick Hodge]

Les

Msgbox "This is the first line"&Chr(13)&"This is the second"

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS

"LesLdh" <[email protected]> wrote in message
news:[email protected]...
>I want to have a msgbox prompt that has two lines of text, eg:
>
> MsgBox("This is the first line
> this is the second line")
>
> I understand that I have to use a carriage return character, but can't
> seem
> to get the syntax right. Can anybody help?
>
> Les.

[Alan Perkins]

Try this:

MsgBox("This is the first line" & vbCrLf & "this is the second line")

HTH

Alan P.

"LesLdh" <[email protected]> wrote in message
news:[email protected]...
>I want to have a msgbox prompt that has two lines of text, eg:
>
> MsgBox("This is the first line
> this is the second line")
>
> I understand that I have to use a carriage return character, but can't
> seem
> to get the syntax right. Can anybody help?
>
> Les.

[Vasant Nanavati]

MsgBox "First line" & vbNewLine & "Second line"

--

Vasant


"LesLdh" <[email protected]> wrote in message
news:[email protected]...
> I want to have a msgbox prompt that has two lines of text, eg:
>
> MsgBox("This is the first line
> this is the second line")
>
> I understand that I have to use a carriage return character, but can't
seem
> to get the syntax right. Can anybody help?
>
> Les.