John,

Use the vbCrLf character to split lines. E.g.,

MsgBox "This is line 1" & vbCrLf & "This is line 2"


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



"john petty" wrote in message
...

Is there any New Line, carriage return or any other
function that can be used to place data in a MsgBox on
separate lines?

Example

this is a test
this was a test
the error is on sheet 2


TIA

John Petty

Thanks Chip
-----Original Message-----
John,

Use the vbCrLf character to split lines. E.g.,

MsgBox "This is line 1" & vbCrLf & "This is line 2"


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



"john petty" wrote in message
...

Is there any New Line, carriage return or any other
function that can be used to place data in a MsgBox on
separate lines?

Example

this is a test
this was a test
the error is on sheet 2


TIA

John Petty


.