splash screen
 

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

splash screen
 

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.

--
Regards,
Tom Ogilvy


"David W" wrote in message
...
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

splash screen
 

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.

--
Regards,
Tom Ogilvy

"John Wilson" wrote in message
...
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

Tom Ogilvy wrote:

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.

--
Regards,
Tom Ogilvy

"David W" wrote in message
...
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

splash screen
 

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

Tom Ogilvy wrote:

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.

--
Regards,
Tom Ogilvy

"David W" wrote in message
...
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