Connecting Strings

[Tom]

Hi All,

How can I connect 2 line of strings, so my massage box will have lines.

i.e Data is missing!
check your entry



Thanks A lot,

Tom

 

[Rick Brandt]

Hi All,

How can I connect 2 line of strings, so my massage box will have
lines.
i.e Data is missing!
check your entry

MsgBox "Data is Missing" & vbCrLf & "check your entry"

Actually in the specific case of a MsgBox you don't need both a Carriage Return
and a Line-Feed so these would also work...

MsgBox "Data is Missing" & vbCr & "check your entry"
MsgBox "Data is Missing" & vbLf & "check your entry"

....but when doing similar things in other contexts you do need both so I tend to
always use vbCrLf. It will not cause two lines in a MsgBox so is harmless.

 

[Tom]

Thank you Rick, working good

MsgBox "Data is Missing" & vbCrLf & "check your entry"

Actually in the specific case of a MsgBox you don't need both a Carriage
Return and a Line-Feed so these would also work...

MsgBox "Data is Missing" & vbCr & "check your entry"
MsgBox "Data is Missing" & vbLf & "check your entry"

...but when doing similar things in other contexts you do need both so I
tend to always use vbCrLf. It will not cause two lines in a MsgBox so is
harmless.