View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jeremy Jeremy is offline
external usenet poster
 
Posts: 14
Default 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!!!