Row return in MSGBOX

[Iain Lewis]

Hi,

Is it possible to show the text in a msgbox on different lines ? eg

Currently :
An email will now be sent to the project manager and to the person responsible for the concern. You will receive a warning message from Outlook - this is normal and OK

which wraps when it gets to the end of the msgbox

Would like :
An email will now be sent to the project manager and to the person responsible for the concern.
You will receive a warning message from Outlook - this is normal and OK

[Ivan F Moala]

On 2002-05-10 01:04, Iain Lewis wrote:
Hi,

Is it possible to show the text in a msgbox on different lines ? eg

Currently :
An email will now be sent to the project manager and to the person responsible for the concern. You will receive a warning message from Outlook - this is normal and OK

which wraps when it gets to the end of the msgbox

Would like :
An email will now be sent to the project manager and to the person responsible for the concern.
You will receive a warning message from Outlook - this is normal and OK

Iain you can wrap text via the use of either
the Chr$ representation of a line feed or
carriage return or the VBA constants

eg "your text 1st line" & vbcr & "next line"

OR

"your text 1st line" & chr(13) & "next line"

[Iain Lewis]

Thanks Ivan. I'd guessed it would be an ASCII character, but didn't know which one. The vbcr is a new one to me.