UserForm won't open automatically

[44macfan]

I can't seem to get my userform to open when the workbook opens.

Sub ShowForm()

UserForm1.Show

End Sub

I have this code in the UserForm Code but the from just flashes up when I open the workbook and then it is gone. What am I doing wrong? I am a bit of a novice with VB so don't laugh too hard at this easy problem.

HELP PLEASE?

 

[Dreamboat]

The only thing I can think is that you've got some other code running afterward that is making something else take focus. Why don't you check here for a sample userform:

http://www.mvps.org/word/FAQs/Userforms/CreateAUserForm.htm

http://www.PiersonTech.com

dreamboat@nni.com
Brainbench MVP for Microsoft Word