I need a UserForm to Auto Start

Debi · Mar 3, 2004

This is the first time I have used VBA in Excel and I'm
having this problem.

In Word, I can have a userform auto load when a template
is opened, but I am having trouble getting this done in
Excel. It seems the same code does not work for Excel...

I write this in the code Modulae for This Document.

Sub AutoNew()
MyForm.Show
End Sub

Is there similar code for Excel?

Bob Phillips · Mar 3, 2004

Debi,

Excel uses Aut

pen

Sub Aut

pen()
MyForm.Show
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Debi · Mar 3, 2004

Thank you so much!!

-----Original Message-----
Debi,

Excel uses Autpen

Sub Autpen()
MyForm.Show
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

.

Debi · Mar 4, 2004

Great suggestion! I tried it and it works perfectly!