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.

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)

"ad klevering" wrote in message
...
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.

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

Ko Vijn

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)

"ad klevering" wrote in message
...
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.