ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Line Feed (https://www.excelbanter.com/excel-programming/323404-line-feed.html)

Nigel Bennett

Line Feed
 
How do I create a msgbox with a line feed between lines ie

msgBox "welcome to this Spreadsheet. Hit ok to continue"

so the text show in 2 lines

Robin Hammond[_2_]

Line Feed
 
Nigel,

Try this

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

Robin Hammond
www.enhanceddatasystems.com

"Nigel Bennett" wrote in message
...
How do I create a msgbox with a line feed between lines ie

msgBox "welcome to this Spreadsheet. Hit ok to continue"

so the text show in 2 lines




Nigel Bennett[_2_]

Line Feed
 


Thanks, that worked perfectly

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


All times are GMT +1. The time now is 11:02 AM.

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