How to display 2 lines in a MsgBox?

sylvest

New Member
Joined
Sep 15, 2006
Messages
46
Hi I would like to display the following in a MsgBox-how should I do it?

Stella
You are lovely!

Thanks,
Syl
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Add a line feed. For example:

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

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
Best be careful.
Stella's big gorilla of a husband may not dig you writing message boxes like that. :LOL:
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
. . . personal experience. :devilish:

Also, if you're still willing to risk it ( :biggrin: ) here are a couple more ways.

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

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

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,371
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top