MsgBox2

[Jack S.]

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

 

[Chip Pearson]

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

 

[Guest]

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







.
I am not trying to have mutilply lines in the title, the

Multiply lines are in the text???

 

[Chip Pearson]

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

 

[Guest]

or

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