Msgbox text hard return

J

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
 
H

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
 
J

JE McGimpsey

One way:

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





Note: vbNewLine works for both WinXL and MacXL.
 
Top