I need a UserForm to Auto Start
 

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?

I need a UserForm to Auto Start
 

Debi,

Excel uses Auto_Open

Sub Auto_Open()
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" wrote in message
...
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?

I need a UserForm to Auto Start
 

Thank you so much!!
-----Original Message-----
Debi,

Excel uses Auto_Open

Sub Auto_Open()
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" wrote in
message
...
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?


.

I need a UserForm to Auto Start
 

Great suggestion! I tried it and it works perfectly!
-----Original Message-----
Debi,
You could also write MyForm.show in workbook open.
That works little faster.
.