View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ko Vijn[_3_] Ko Vijn[_3_] is offline
external usenet poster
 
Posts: 6
Default 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.