1. In the workbook_open event, which is found in the VBA editor, "This Woorkbook" module, enter the line:
The whole lot should look thus:
Code:
Private Sub Workbook_Open()
userform1.show
End Sub
.............. in both of these cases substituting the userform1 reference to that of your userform in question.
Now, each time your workbook opens, the code will run, and the useform will be shown.
2. Control button.....
Draw the button onto the worksheet, right click/view code/ and put the lines of code inside the two visible lines.
So, if you want a message box to fire from the button, put the line:
Code:
Msgbox "Hello again melibeth!"
within the two sub lines thus:
Code:
Private Sub CommandButton1_Click()
Msgbox "Hello again melibeth!"
End Sub
When you're done, be sure to come out of design mode with your worksheet before trying the button.
3.Yes, you can do this in Word.