ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Msg Box (https://www.excelbanter.com/excel-programming/305750-msg-box.html)

joe user

Msg Box
 
how do I send Chr$(10) to a msgbox so I can have a
sentence in a msgbox on it's own line?

JE McGimpsey

Msg Box
 
one way (that works cross-platform):

MsgBox "Sentence 1." & vbNewLine & "Sentence 2."

In article ,
"joe user" wrote:

how do I send Chr$(10) to a msgbox so I can have a
sentence in a msgbox on it's own line?


Tom Ogilvy

Msg Box
 
or for just Chr$(10)

MsgBox "This is line 1" & vbLf & _
"This is line 2"


or

MsgBox "This is line 1" & chr$(10) & _
"This is line 2"


--
Regards,
Tom Ogilvy

"joe user" wrote in message
...
how do I send Chr$(10) to a msgbox so I can have a
sentence in a msgbox on it's own line?





All times are GMT +1. The time now is 05:31 AM.

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