splash screen

  • Thread starter Thread starter David W
  • Start date Start date
D

David W

Is there a way to have a splash screen show and make your processes run
while the screen is active.
What is happening now is the screen will show, it waits its time, then it
kills itself, then runs the processes.
I have tried screenupdating to false before and after my processes, but I
still get a flickering effect during the workbooks calculations THIS TOTAL
FREAKS PEOPLE OUT TO SEE A SCREEN FLICKER. THIS IS A PROBLEM FOR THEM. They
think someting is wrong. Can you help
Thanks
David
 
You should put up your splash screen and have it run the processing code
from the userforms activate event. Then when the processing completes, the
next line is me.unload.
 
use
DoEvents
' start the process


or
DoEvents
me.repaint
DoEvents
' start the process
rather than Wait.

See if that works.

If you are updating your labels during the processing, then you probably
want DoEvents after the updates as well.
 
Tom,

Ya' know, I never thought of doing it quite that way.
Neat idea and it works too (not that I doubted you).
One minor problem is that the UserForm (at least mine anyway,
since I'm populating labels when I open it), comes up blank.
It almost seems like my sub starts running before the UserForm
has had a chance to display what I want even though I call the sub
at the very end of the Activate Event (just before the Unload).
I was able to cure this by placing a 1 second "Wait" statement
before running my code from within the UserForm Activate Event.
Is this normal or is there a better way??

And thanks again for the great idea.

John
 
Back
Top