from userform to userform.

A

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.
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top