MsgBox2

J

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
 
C

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
 
G

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
Click to expand...
Multiply lines are in the text???
 
C

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
 
Top