from userform to userform.
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.
|