Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splash Screen | New Users to Excel | |||
Splash Screen | Excel Discussion (Misc queries) | |||
splash screen | Excel Discussion (Misc queries) | |||
splash screen | Excel Discussion (Misc queries) | |||
Splash Screen Startup | Excel Discussion (Misc queries) |