Msgbox Multi-line

[Skip Bisconer]

I have tried every combination of Chr(13)+Chr(10) and vbCrLf to get VBA to accept a second line in my msgbox prompt. It's apparant I don't know what I am doing because it justs goes red. Can anyone help me? Thanks

 

[Russell Hauf]

On 2002-10-22 17:00, Skip Bisconer wrote:
I have tried every combination of Chr(13)+Chr(10) and vbCrLf to get VBA to accept a second line in my msgbox prompt. It's apparant I don't know what I am doing because it justs goes red. Can anyone help me? Thanks

I think you're probably wanting the _ continuation character in VBA. One thing to remember is that you can have several MSGBOX lines in one VBA line:

MsgBox "line1" & vbCrLf & "line2" & vbCrLf & "line3" & vbCrLf & "line4"

But if you want to have multiple lines in VBA, then you need the underscore continuation character:

    MsgBox "line1" & vbCrLf & _
           "line2" & vbCrLf & _
           "line3" & vbCrLf & _
           "line4"

HTH,

Russell

 

[Chas17]

Sub hi()
msg = "This is line one"
msg = msg & vbCrLf & "This is line Two"
MsgBox msg
End Sub