How to Show Splash Screen While Running Macros

[madhuchelliah]

Hey Guys, I want to show splash screen while the macro starts and and close after the macros ends. I searched lot, i am getting only time based splash screens. Is there any method to execute splash screen irrespective of time?. Its should work w.r.t macro running time. Time varies based on input. Please help.

 

[Sharid]

Not really an expert here, but what the hell. lol

This is for a timed Splash screen called UserForm1 showed on Sheet called "Cover", once the time finished the toolbar showed. Could you not just change the code so its reads as -

Private Sub Workbook_Open()
Sheets("Cover").Activate
Load UserForm1
Application.OnTime Now + TimeValue("00:00:12"), "HideSplash"
UserForm1.Show

Toolbar.Show

End Sub

Changed to -

Private Sub Workbook_Open()
Sheets("Cover").Activate

Load UserForm1
UserForm1.Show

**** Your Code here*****

UserForm1.Hide

End Sub