Is Multi line possible with MsgBox
 

Is it possible to have this in multiple lines, instead of just one single line?

MsgBox "An Error as occurred in the Save file to folder. This Macro will now
TERMINATED"

Is Multi line possible with MsgBox
 

On Sep 5, 4:32 pm, Ayo wrote:
Is it possible to have this in multiple lines, instead of just one single line?

MsgBox "An Error as occurred in the Save file to folder. This Macro will now
TERMINATED"

The string chr(13) will provide a carriage return. For example

MsgBox "An Error as occurred in the Save file to folder." & chr(13) &
"This Macro will now
TERMINATED"

Is Multi line possible with MsgBox
 

Try

MsgBox "Line One" & vbCrLf & _
"Line Two"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Ayo" wrote in message
...
Is it possible to have this in multiple lines, instead of just one single
line?

MsgBox "An Error as occurred in the Save file to folder. This Macro will
now
TERMINATED"

Is Multi line possible with MsgBox
 

example:

MsgBox "Line 1" & vbNewLine & "Line 2"


--
Hope that helps.

Vergel Adriano


"Ayo" wrote:

Is it possible to have this in multiple lines, instead of just one single line?

MsgBox "An Error as occurred in the Save file to folder. This Macro will now
TERMINATED"

Is Multi line possible with MsgBox
 

Is it possible to have this in multiple lines, instead of just one single
line?

MsgBox "An Error as occurred in the Save file to folder. This Macro will
now
TERMINATED"

The string chr(13) will provide a carriage return. For example

MsgBox "An Error as occurred in the Save file to folder." & chr(13) &
"This Macro will now
TERMINATED"

Or, you can use the built-in VB constant for carriage returns, vbCr...

MsgBox "An Error as occurred in the Save file to folder." & vbCr & "This
Macro will now TERMINATED"

If you want a blank line between the sentences for visual looks reasons, use
two vbCr characters...

MsgBox "An Error as occurred in the Save file to folder." & vbCr & vbCr &
"This Macro will now TERMINATED"

Note: I'm sure your newsreader will split the above lines into more than one
line, but they are just single code lines.

Rick