Msgbox text hard return

[Jo]

Hi
How do I set up my message box to say
blah, blah, blah
etc., etc.
rather than
blah, blah, blah etc., etc.
That is I want a line return between my txt rather than a
really long message box.
Thanks
Jo

 

[Harald Staff]

Hi Jo

Sub test()
MsgBox "blah blah" & Chr(10) & _
"yet another blah" & Chr(10) & Chr(10) & _
"don't touch that dial"
End Sub

HTH. Best wishes Harald

 

[JE McGimpsey]

One way:

MsgBox "blah, blah, blah" & vbNewLine & "etc., etc."





Note: vbNewLine works for both WinXL and MacXL.