from userform to userform.

[ad klevering]

Dear all,
I am creating a excell-file in with a userform comes up after opening of the
file. Like a fash screen,so far so good. How can I close this first userform
and open a second userform inwith there are commandbuttons and textboxes?
I now how to open a second userform without these controls, thats no
problem.

Best regards,
Ad.

 

[Bob Phillips]

Ad,

Use the OntIme method in the code that start the first form. Something like
this

Sub ShowForms()
Application.OnTime Now + TimeValue("00:00:05"), "CloseSplash"
UserForm1.Show

End Sub


Sub CloseSplash()
Unload UserForm1
UserForm2.Show
End Sub


--

HTH

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

 

[Ko Vijn]

This worked with me when I added vbModeless after Userform1.show

Ko Vijn