ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code to make a New line in a message (https://www.excelbanter.com/excel-programming/277459-code-make-new-line-message.html)

John Parham

Code to make a New line in a message
 
i am writing code for a message box to pop up at certain errors in the users
interaction but the message is quite long and I want to break it down onto 2
or 3 lines. I know it is some thing like

&nb??&. can you help please



Jean-Paul Viel

Code to make a New line in a message
 
Hi



vbCrLf or Chr(10) & Chr(13)




--
JP

http://www.solutionsvba.com


"John Parham" wrote in message
...
i am writing code for a message box to pop up at certain errors in the

users
interaction but the message is quite long and I want to break it down onto

2
or 3 lines. I know it is some thing like

&nb??&. can you help please





Dianne

Code to make a New line in a message
 
"John Parham" wrote in message
...
i am writing code for a message box to pop up at certain errors in the

users
interaction but the message is quite long and I want to break it down onto

2
or 3 lines. I know it is some thing like

&nb??&. can you help please


MsgBox ("First line" & vbNewLine & "Second line" & vbNewLine & vbNewLine &
"Another line")

--
Dianne




All times are GMT +1. The time now is 01:30 PM.

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