ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   new line in msgbox text (https://www.excelbanter.com/excel-programming/317920-new-line-msgbox-text.html)

Patrick

new line in msgbox text
 
what character(s) do you use to put a new line in msgbox text

msgbox "This is on one line ??? This is on the next"

I expect its easy but have tried lots of things!

Thanks
--
Patrick

Norman Jones

new line in msgbox text
 
Hi Patrick,

Try:

MsgBox "This is on one line " & vbNewLine & "This is on the next"

---
Regards,
Norman



"Patrick" wrote in message
...
what character(s) do you use to put a new line in msgbox text

msgbox "This is on one line ??? This is on the next"

I expect its easy but have tried lots of things!

Thanks
--
Patrick




Nigel

new line in msgbox text
 
Try

msgbox "Text Line 1" & vbcrlf & "Text Line 2"

Cheers
Nigel

"Patrick" wrote in message
...
what character(s) do you use to put a new line in msgbox text

msgbox "This is on one line ??? This is on the next"

I expect its easy but have tried lots of things!

Thanks
--
Patrick





All times are GMT +1. The time now is 12:07 PM.

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