ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MsgBox text on several lines (https://www.excelbanter.com/excel-discussion-misc-queries/166979-msgbox-text-several-lines.html)

mohavv

MsgBox text on several lines
 
Hi,

How can I start a new line in a MsgBox?
All the text I enter is written behind each other. It would be more
clear to have it in serveral lines.

like this:

ATTENTION
Yes to ....
No to ...

Cheers,

Harold

Paul B

MsgBox text on several lines
 
Harold, here is one way

MsgBox ("First Line" & Chr(10) & "Second Line")


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"mohavv" wrote in message
...
Hi,

How can I start a new line in a MsgBox?
All the text I enter is written behind each other. It would be more
clear to have it in serveral lines.

like this:

ATTENTION
Yes to ....
No to ...

Cheers,

Harold





All times are GMT +1. The time now is 01:33 AM.

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