Splash Form, the open another form

[erutherford]

I have a simple splash form that closes after .05 seconds. At the end of the splash form closing, I want to open an other form.

Private Sub UserForm_Activate()
    Application.OnTime Now + TimeValue("00:00:04"), "KillTheForm"

Form("UserForm1").Select

End Sub


I thought it would work the same as "sheets!", but nope. any ideas? still searching.


thanks

 

[AlphaFrog]

UserForm1.Show

 

[erutherford]

yep that works. I just had to find the right location (this workbook)

Private Sub Workbook_Open()
UserForm2.Show
UserForm1.Show
End Sub

thanks!