splash screen

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
 
T

Tom Ogilvy

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.
 
T

Tom Ogilvy

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.
 
J

John Wilson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top