ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   linefeed in msgbox (https://www.excelbanter.com/excel-programming/447751-linefeed-msgbox.html)

[email protected]

linefeed in msgbox
 
Hi, all.

I would like a linefeed on a msgbox. I know you can use a vba constant vbCr but where do I put it?
msgbox "hi, how are you? " vbCr "I'm fine, thank you." resulted in an error.

any help is much appreciated.

greets,

sybolt

Claus Busch

linefeed in msgbox
 
Hi,

Am Thu, 29 Nov 2012 00:24:26 -0800 (PST) schrieb :

I would like a linefeed on a msgbox. I know you can use a vba constant vbCr but where do I put it?
msgbox "hi, how are you? " vbCr "I'm fine, thank you." resulted in an error.


try:
MsgBox "hi, how are you? " & vbCr _
& "I'm fine, thank you."


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

[email protected]

linefeed in msgbox
 
Claus,

Thanks a lot.
The ampersands did the job. Great.

Sybolt


All times are GMT +1. The time now is 02:58 PM.

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