You can't have multiple lines in the Title of a message box.
Therefore, get rid of all your Chr(10), as well as the vbCritical
at the end. You might try
MsgBox "Text", vbOKOnly + vbCritical, "Title"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Jack S." wrote in message
...
Thanks for the responses I receieved from Chip & Alex.
However, I can not get either response to change the
title from Excel to my title. I have;
MsgBox "Text 1", vbOKOnly, "Title" & Chr(10) & Chr(10) & _
"Text2" & Chr(10) & _
"Text3" & Chr(10) & _
"Text4", vbCritical
Anyother ideas?
Thanks