ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MsgBox carriage return (https://www.excelbanter.com/excel-programming/280143-msgbox-carriage-return.html)

art

MsgBox carriage return
 
I can't remember the code to insert a carriage return
within the message line of a MsgBox, so that you can
control how the message appears.

Tom Ogilvy

MsgBox carriage return
 
"ABCD" & vbNewLine & "EFGH"

or vbCrLF or vbLF or vbCr

--
Regards,
Tom Ogilvy


"Art" wrote in message
...
I can't remember the code to insert a carriage return
within the message line of a MsgBox, so that you can
control how the message appears.




Chip Pearson

MsgBox carriage return
 
Art,

Try something like

MsgBox "First Line" & vbCrLf & "Next Line"


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


"Art" wrote in message
...
I can't remember the code to insert a carriage return
within the message line of a MsgBox, so that you can
control how the message appears.





All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com