How to display 2 lines in a MsgBox?

sylvest · Oct 13, 2006

Hi I would like to display the following in a MsgBox-how should I do it?

Stella
You are lovely!

Thanks,
Syl

Von Pookie · Oct 13, 2006

Add a line feed. For example:

Code:

Msgbox "Stella" & vbCrLf & "You are lovely!"

HalfAce · Oct 13, 2006

Best be careful.
Stella's big gorilla of a husband may not dig you writing message boxes like that.

pookie62 · Oct 13, 2006

Best be careful.
Stella's big gorilla of a husband may not dig you writing message boxes like that.

How do you know that ?!?!?

HalfAce · Oct 13, 2006

. . . personal experience.

Also, if you're still willing to risk it (

) here are a couple more ways.

MsgBox "Stella" & Chr(10) & "You are lovely."

MsgBox "Stella" & vbNewLine & "You are lovely."