This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.
VBA:
You can suppress the messages with:
Application.DisplayAlerts = False
Don't forget to turn them back on when you are finished with:
Application.DisplayAlerts = True
10.3 How do I put multiline text string in a message box? (spreadsheets: Excel)
VBA:
MsgBox _
"This will print on line one" & Chr(13) & _
"this will print on line two"
 
Continue to: