Thread: MsgBox2
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default MsgBox2

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