MrExcel Publishing
Your One Stop for Excel Tips & Solutions

vbleft


Posted by Qroozn on January 14, 2002 3:12 PM

how do you use vbleft to take part of a message to the next line


Posted by Lafeu on January 14, 2002 3:40 PM

Try something like this:

MsgBox "This is the first line" & vbcrlf & _
"And this is the second line."

Posted by Russell Hauf on January 14, 2002 3:40 PM

You don't!

Try something like this:

MsgBox "This is the first line" & vbcrlf & _
"And this is the second line."

Posted by Nate Oliver on January 14, 2002 3:53 PM

Another method

Or, this...

Sub test()
MsgBox "This is the first line" & Chr(13) & _
"And this is the second line."
End Sub

Sub test2()
MsgBox "This is the first line" & Chr(13) & _
"" & Chr(13) & "And this is the second line."
End Sub

Posted by Nate Oliver on January 14, 2002 3:53 PM

Another method

Or, this...

Sub test()
MsgBox "This is the first line" & Chr(13) & _
"And this is the second line."
End Sub

Sub test2()
MsgBox "This is the first line" & Chr(13) & _
"" & Chr(13) & "And this is the second line."
End Sub

Posted by Qroozn on January 14, 2002 4:11 PM

Thanks guys. Vbcrlf is what i was looking for.


Thanks for the assistance