Thread
:
display multiple lines in pop up when workbook opens
View Single Post
#
2
Posted to microsoft.public.excel.programming
Jeremy
external usenet poster
Posts: 14
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!!!
Reply With Quote
Jeremy
View Public Profile
Find all posts by Jeremy