Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Loading..." Splash Screen in Excel
Try this approach,
Create a userform with the 'splash' details Instead of running -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Gary Phillips" wrote in message ... Okay, I've been tasked with putting a "loading splash screen" on the screen while a macro works in the background (this macro could take 30-45 seconds). So I created a simple dialog box and have it show itself while the macro is loading. Once it finishes I have it hide itself but it doesn't work. (Box1.Hide) Instead, the user has to click the x button to close the dialog box. How can I make the dialog box close itself? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: top of screen "File Name [Group]", how to remove [Grou | Excel Discussion (Misc queries) | |||
"File Open" box Excel is full screen, how can I size it down? | Excel Discussion (Misc queries) | |||
"Document not saved" "error in loading DLL" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel automation "Error loading DLL" | Excel Programming |