Pop Up Message on Open

[Emaleth]

Hiya - I need help with some code.

I've created a form and need instructions in a pop up window to go with it.

What I would like to do...when you click the form to open - the first thing you see is a pop up window that says - Instructions...select items from drop down list, click outside drop down list to exit, click check boxes, etc., and then once they read the instructions and close the pop up the form opens and is ready to use.

Much thanks for your help.

Cheers ~ E

 

[Emaleth]

Sorry, forgot to mention that it is Execl 2007 using Vista. Cheers ~ E

 

[VoG]

Is this a UserForm or a worksheet?

 

[Emaleth]

User form

 

[VoG]

Try like this in the userform's code window

Private Sub UserForm_Activate()
MsgBox "Instructions" & vbNewLine & "Line1" & vbNewLine & "Line2"
End Sub