General Message Box Question

[EMoe]

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

[dominicb]

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

[EMoe]

It works!!! Thanks a bunch.

Regards,
EMoe

[Tom Ogilvy]

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


--
Regards,
Tom Ogilvy




"EMoe" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Chip Pearson]

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" <[email protected]> wrote
in message
news:[email protected]...
>
> 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
>

[dominicb]

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