Pop-Up Notification Box ??????

[beiringf]

Can anyone tell me how to create a notification box pop-up that will open when I open the excel file. This will be a notification box that will list instructions on how to use the excel spreadsheet I am creating. Any help would be greatly appreciated!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[VoG]

Right click the Excel logo just to the left of File on the menu bar, select View Code and paste in

Private Sub Workbook_Open()
MsgBox "Line 1" & vbCrLf & "Line2" & vbCrLf & "Line3" & vbCrLf, vbInformation
End Sub

Change Line1 etc to your instruction text (add more lines as required).

 

[beiringf]

Would these be the same steps for excel 2003 as well? Sorry but we use an ancient version of excel. And thank you for your help!

 

[VoG]

Yes, all versions from 97 to 2003. XL 2007 is slightly different in the way that you access the code module.

 

[beiringf]

Great! Thank you so much!!!!!!!!