message box, how to divide the inf into different lines?

M

Martin

For example, my VBA is now like this:

MsgBox "aaaaaaaaaabbbbbbbbbbbcccccccccc", , "Hints!"


I want to make the message box showing that:

aaaaaaaaaa
bbbbbbbbbb
cccccccccc


INSTEAD OF:
aaaaaaaaabbbbbbbbbbbcccccccccc



QUESTION: How should the VBA sentences changed into ?



Thank you.
 
D

David Lloyd

Martin:

You could try something like the following:

MsgBox "aaaaaaaaaa" & vbCrLf & "bbbbbbbbbbb" & vbCrLf & "cccccccccc", ,
"Hints!"


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.



For example, my VBA is now like this:

MsgBox "aaaaaaaaaabbbbbbbbbbbcccccccccc", , "Hints!"


I want to make the message box showing that:

aaaaaaaaaa
bbbbbbbbbb
cccccccccc


INSTEAD OF:
aaaaaaaaabbbbbbbbbbbcccccccccc



QUESTION: How should the VBA sentences changed into ?



Thank you.
 
Top