Pop-up message on startup

[brandonh]

I'd like to display a pop-up message on startup for an Excel file. The message would simply give a brief 3-step on how to use the file (calculations, etc.)

I've created pop-ups to validate cells before, but not this. Anyone have a way for me to do this?

Thanks.

 

[VoG]

Hello and welcome to MrExcel.

right click the Excel logo just to the left of File on the menu bar and paste in

[/code]
Private Sub Workbook_Open()
MsgBox "Your message goes here"
End Sub
[/code]]

 

[boileauj]

You can create a MsgBox that is displayed when the Excel file is loaded.

In the VB editor select ThisWorkbook.
Write a procedure including the following code:


Private Sub Workbook_Open()

MsgBox("YourInformationHere")

End Sub



This will display a MsgBox when you open the spreadsheet that will have the information you want to have displayed and allow the user to click OK when done reading it.

If you need any more help with this let me know

 

[brandonh]

Thanks guys. Is there a way to then invoke the message box by clicking on a button that I put on the page...through either of these two options.

Thanks!

 

[VoG]

Press ALT + F11 to open the Visual Basic Editor, select Module from the Insert menu and paste into the white space on the right

Sub MyMsg()
MsgBox "Step 1: do this" & vbCrLf & "Step 2: do that" & vbCrLf & "Step 3: do the other", vbInformation, "Instructions for Use"
End Sub

Press ALT + Q to return to your sheet. View > Toolbars > Forms, click on the button tool and draw out a button on the sheet. When prompted to assign a macro select MyMsg.