MsgBox Question
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 |
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 . |
All times are GMT +1. The time now is 07:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com