Thread: MsgBox Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
john Petty john Petty is offline
external usenet poster
  
Posts: 23
Default MsgBox Question
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


.

Reply With QuoteReply With Quote