Splash screen
Posted by Phill Paige on October 14, 2001 9:20 AM
Not really a macro question - what a refreshing change I hear the veterans cry! - but how about this? - I have a fairly sizeable sheet (7meg!) that takes about 20 secs or so to load that gets distributed quite widely in the company I work for - What I would like to do is have a Loading screen (ideally that occupies the whole screen) - any thoughts or examples very welcome.
Rgds
Phill
Posted by Jim on October 14, 2001 11:37 AM
Hi Phill,
You can create a splash screen by way of a userform
but it won't be seen until your file is loaded,
so for what you need it probably wouldn't be of
any help.
Private Sub UserForm_Activate()
Application.OnTime Now + TimeValue("00:00:05") _
"KillTheForm"
End Sub
Regards, Jim
Not really a macro question - what a refreshing change I hear the veterans cry! - but how about this? - I have a fairly sizeable sheet (7meg!) that takes about 20 secs or so to load that gets distributed quite widely in the company I work for - What I would like to do is have a Loading screen (ideally that occupies the whole screen) - any thoughts or examples very welcome.
