Thread: Two lines in a msg box on open?

I need a msg to pop up when a worksheet opens. Pretty simple:

Private Sub Workbook_Open()
If MsgBox("My msg goes here!") Then
Exit Sub
End If
End Sub


But I need to be able to have multiple lines, maybe a short paragraph.
How do you get it to allow additional lines?

Thanks!

this is how you add lines

Code:

Sub test()

MsgBox "My msg goes here!" & vbCrLf & "this is second line"
End Sub

jzibton,

Try:

Code:

Sub TestMessage()

MsgBox "I need a msg to pop up when a worksheet opens. Pretty simple:" & vbCrLf & vbCrLf & _
  "But I need to be able to have multiple lines, maybe a short paragraph." & vbCrLf & vbCrLf & _
  "How do you get it to allow additional lines?"

End Sub

It will create a three line message with double spacing.

jzibton

Please take a couple of minutes and read ALL theForum Rules then wrap your VBA code (Rule 3)