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

Bill Jelen is the author / co-author of
Excel Subtotals Straight to the Point

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.