OnLoad / buttons on worksheet itself

[melibeth]

How do I show a user form as soon as my .xls file opens?
How to you put a control button on a worksheet and then assign macros to it?
Does anyone know if you can also do this in Word.

Thanks!!!!!!!!!!!!

 

[sykes]

1. In the workbook_open event, which is found in the VBA editor, "This Woorkbook" module, enter the line:

userform1.show

The whole lot should look thus:

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:

Msgbox "Hello again melibeth!"

within the two sub lines thus:

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.