Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Loading..." Splash Screen in Excel
Try again.
Try this approach, Create a userform with the 'splash' details Instead of running the macro, load the form and have the form run the macro in it's Activate event. When the macro completes, unload the form programmatically. Something like Private Sub UserForm_Activate() myMacro Unload Me End Sub -- 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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Loading..." Splash Screen in Excel
Okay, I've got it working except that when it loads the splash screen form it doesn't show the label. The actual body of the form is all white. Why isn't it loading the label on the form (that says the text "Loading...") Any ideas? (I even set ScreenUpdating to TRUE and that still didn't fix it.)
"Bob Phillips" wrote: Try again. Try this approach, Create a userform with the 'splash' details Instead of running the macro, load the form and have the form run the macro in it's Activate event. When the macro completes, unload the form programmatically. Something like Private Sub UserForm_Activate() myMacro Unload Me End Sub -- 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Loading..." Splash Screen in Excel
I f your form is named MyForm, then:
Load MyForm will load your form into memory. MyForm.Show loads your form into memory (if it hasn't been already) and displays it also. MyForm.Hide hides your form but keeps it in memory. Unload MyForm hides your form (if it's being displayed) and also unloads it from memory. HTH. -gk- "Gary Phillips" wrote in message ... Okay, here's a stupid question. How do I load the form now? I tried to just Label1.Show but it didn't work. "Bob Phillips" wrote: Try again. Try this approach, Create a userform with the 'splash' details Instead of running the macro, load the form and have the form run the macro in it's Activate event. When the macro completes, unload the form programmatically. Something like Private Sub UserForm_Activate() myMacro Unload Me End Sub -- 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Loading..." Splash Screen in Excel
Try setting the 'Showmodal' property of the form to False, providing yo
are not on 97 -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Loading..." Splash Screen in Excel
Gary,
precede the macro call with Me.Repaint -- 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, here's a stupid question. How do I load the form now? I tried to just Label1.Show but it didn't work. "Bob Phillips" wrote: Try again. Try this approach, Create a userform with the 'splash' details Instead of running the macro, load the form and have the form run the macro in it's Activate event. When the macro completes, unload the form programmatically. Something like Private Sub UserForm_Activate() myMacro Unload Me End Sub -- 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) | |||
"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) | |||
"Loading..." Splash Screen in Excel | Excel Programming | |||
Excel automation "Error loading DLL" | Excel Programming |