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

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

-----Original Message-----
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


.
I am not trying to have mutilply lines in the title, the
Multiply lines are in the text???

If you want multiple lines in the text message portion of the
MsgBox, use code like

MsgBox "Line 1" & vbNewLine & "Line 2" & vbNewLine & _
"Line 3", vbOKOnly, "Title Text Goes Here"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



wrote in message
...

-----Original Message-----
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


.
I am not trying to have mutilply lines in the title, the
Multiply lines are in the text???

or

MsgBox "Text1" & chr(13) & "Text2" & chr(13), vbOkOnly, "Title"



"Chip Pearson" wrote:

If you want multiple lines in the text message portion of the
MsgBox, use code like

MsgBox "Line 1" & vbNewLine & "Line 2" & vbNewLine & _
"Line 3", vbOKOnly, "Title Text Goes Here"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



wrote in message
...

-----Original Message-----
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


.
I am not trying to have mutilply lines in the title, the
Multiply lines are in the text???