display multiple lines in pop up when workbook opens

's Computer Specifications

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!!!

's Computer Specifications

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.

(E-Mail Removed) 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!!!

's Computer Specifications

Thank you very much Jeremy

's Computer Specifications

Thank you very much Jeremy

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opens multiple versions of workbook	LKB	Microsoft Excel Misc	0	18th Sep 2009 10:35 PM
Excel opens multiple copies of workbook	=?Utf-8?B?U05H?=	Microsoft Excel Misc	1	11th Oct 2007 04:13 PM
I need to copy & paste multiple lines to another workbook?	=?Utf-8?B?Smlt?=	Microsoft Excel Worksheet Functions	3	11th Apr 2007 01:17 AM
display 1 line of multiple worksheets into multiple lines on 1 wks	=?Utf-8?B?R29sZiBOdXQ=?=	Microsoft Excel Worksheet Functions	1	5th Oct 2006 08:28 AM
Display multiple lines of text within a cell from multiple column.	=?Utf-8?B?WmVlc2hhbiBaYWhlZXI=?=	Microsoft Excel Worksheet Functions	3	23rd Aug 2006 10:08 AM