Adding multiple rows of text in a Msgbox.!

Hi Forum.!

I believe this would be a very simple query for some but I am a complete novice in VBa and am using a msgbox in one of my file but I need to split the message text into multiple lines but I do not know how to do the same..

Can someone please guide me ?

Good afternoon e4excel
[QUOTE=e4excel;2176431]am using a msgbox in one of my file but I need to split the message text into multiple lines QUOTE]

MsgBox "Line1" & Chr(13) & "Line2" & Chr(13) & "Line3"

HTH

DominicB

Hi! Dominic

and a very good afternoon to you....By the way its a lovely evening out here....

It worked very well, and it looks fine...
Just wanted to know confirm that chr(13) is equivalent to Enter ",<__l "

and also in the VBA Modules window, is there a way of writing the code in the next line...for the same line as in this case the Msgbox text was going beyond the normal viewable portion.

Thanks a lot for the help..!

I am not able to mark this thread as solved as am not getting the option prefix after going in EDIT->Go Advanced.. kIndly guide me for the same as well..

    MsgBox "Line1" & Chr(10) _
         & "Line2" & Chr(10) _
         & "Line3"

Hi e4excel

You need to do this on your first post - otherwise the dropdown isn't there.

I've done it for you.

DominicB