How to run splash screen userform while another userform is loading?

[danbates]

Hi,

I have just created a splash screen userform with help from the internet.

What I would like to do now is run the splash screen userform at the same time as my other userform but with only having the splash screen userform visible until my other userform has loaded.

Splash screen userform is called = SplashUserForm
other userform is called = STATSFORM

Any help would be appreciated.

Thanks

Dan

 

[jmacleary]

Hi there. try this - set up your userform initialise routine for your STATSFORM like this (I just put a msgbox in so you could see the eff3ect:

Private Sub UserForm_Initialize()
SplashUserForm.Show vbModeless
' now have your initialise code here
ans = MsgBox("Wait", vbYesNo)
Unload SplashUserForm
End Sub

 

[danbates]

Hi John,

It's working so thank you for your code.

Dan

 

[jmacleary]

You're welcome and thanks for the feedback.