display multiple lines in pop up when workbook opens
 

I have this code in my "thisworkbook"

Private Sub Workbook_Open()
MsgBox "NOTES/DIRECTIONS:1....2...."
End Sub


however, i would like to display the 1 and 2 and so on in new rows in
the pop up like this

NOTES/DIRECTIONS
1. flaksdjfkldjfsdf
2. lkasdjfl;kasdjflkjsdf

Can this be done??

Thank you in advance if anyone can help!!!

display multiple lines in pop up when workbook opens
 

I think what you're looking for is:

msgbox "Notes/Directions" & vbCrLf & "Direction 1" & vbCrLf &
"Direction 2"

I'm pretty sure there's a limit on how much text a messagebox can
contain, though, so if it's long, I suggest using a userform instead.

wrote:
I have this code in my "thisworkbook"

Private Sub Workbook_Open()
MsgBox "NOTES/DIRECTIONS:1....2...."
End Sub


however, i would like to display the 1 and 2 and so on in new rows in
the pop up like this

NOTES/DIRECTIONS
1. flaksdjfkldjfsdf
2. lkasdjfl;kasdjflkjsdf

Can this be done??

Thank you in advance if anyone can help!!!

display multiple lines in pop up when workbook opens
 

Thank you very much Jeremy

display multiple lines in pop up when workbook opens
 

Thank you very much Jeremy