Multi-line msgbox

[Guest]

i'm having a problem with my msgbox, my msgbox get too long because of my
prompt, how can i make my msgbox short without editing my prompt?
guys i need your help
thanks
resti

 

[Allen Browne]

You will have to edit your prompt.

Try:
MsgBox "Line1" & Chr(13) & Chr(10) & "Line 2"

This inserts a carriage return and line feed into the string.

 

[Guest]

thanks allen for the help, god bless

You will have to edit your prompt.

Try:
MsgBox "Line1" & Chr(13) & Chr(10) & "Line 2"

This inserts a carriage return and line feed into the string.

 

[Chuck Wood]

I find it easier to use the vbCrLf syntax. For example:

MsgBox "Line1" & vbCrLf & "Line 2" vbCrLf & "Line 3"

I think it reads a little better.

 

[Allen Browne]

Yes, that's much better in code.

Not suitable for macro though.