Whenever you prompt a message box, using this format:

returnvalue = MsgBox("Did you remember to log in your
name?",64,"Message")

If I had a long statement or wanted to add a second sentence, is it
possible
(or how do you), continue or put the second sentenceon another line?

Or does excel just place everything on one line?

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=374589

Sub a()
msg = "line1" & vbNewLine & "Line2"
returnvalue = MsgBox(msg, 64, "title")
End Sub


--
Regards,
Tom Ogilvy




"EMoe" wrote in message
...

Whenever you prompt a message box, using this format:

returnvalue = MsgBox("Did you remember to log in your
name?",64,"Message")

If I had a long statement or wanted to add a second sentence, is it
possible
(or how do you), continue or put the second sentenceon another line?

Or does excel just place everything on one line?

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile:
http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=374589

Use vbNewLine to break text up in to multiple lines. E.g.,

MsgBox "Line one" & vbNewLine & "Line two"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"EMoe" wrote
in message
...

Whenever you prompt a message box, using this format:

returnvalue = MsgBox("Did you remember to log in your
name?",64,"Message")

If I had a long statement or wanted to add a second sentence,
is it
possible
(or how do you), continue or put the second sentenceon another
line?

Or does excel just place everything on one line?

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile:
http://www.excelforum.com/member.php...o&userid=23183
View this thread:
http://www.excelforum.com/showthread...hreadid=374589

Hi Emoe

No problem, I appreciate the feedback.

However, it seem that our questions posts are now duplicated on the
Microsoft site, but (judging from the response) not the answers
posted!

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=374589

Good evening Emoe

There are two ways of doing it, both demostrated in this macro. Take
your pick.

Sub example()
MsgBox "This is line 1" & vbLf & "This is line 2" _
& Chr(13) & "This is line 3"
End Sub

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=374589

It works!!! Thanks a bunch.

Regards,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=374589