MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Multiple Lines in Message Box

January 27, 2002 - by Bill Jelen

Robert asks:

Could you tell me how to break an expression of Msgbox into 3 lines and insert a blank line into such an expression?

Use this code:

Msg = "This is line 1" & vbCr & "This is Line 2 " & vbCr & vbCr & "This is Line 4"
Msgbox Prompt:=Msg