Next line in message box

[GMcFly]

Hi all,
I have a message which I want to have on several lines in a message box. For example if my message is "Tek-Tips is very cool and is worth adding to your favorites" I would like it to appear like this:

Tek-Tips is very cool
and is worth adding to your
favorites

on 3 different lines in the box
How can I do this? Thanks for your help

 

[sha76]

MsgBox "Tek-Tips is very cool" & Chr(13) & "and is worth adding to your" & Chr(13) & "favorites"

 

[GMcFly]

Cool!! Thanks a lot, all I needed!

 

[Nikita6003]

Just out of interest:

VBA has these two constants:

vbCrLf

and

vbLf

Makes your code easier to read ...

Cheers
Nikki

 

[young]

vbNewline also works well.

 

[GMcFly]

Thank you all for your help!