About Us

MWS

Thank You GS - I Really Appreciate Your Assistance - Take Care

"GS" wrote:

Hi MWS,

Sorry, I have no idea why the form doesn't display "as designed". You may
want to go through the its properties to see if the answer lies there.

Also, you don't need the load statement unless you plan on doing something
with the form before making it visible. The .Show method loads it if it's not
already loaded. (Not to be confused with .Hide, which leaves it loaded)

Hope this is helpful!
GS

"MWS" wrote:

Thank You GS, I appreciate your help.

I added the following code and it almost* works perfectly:

Load frmOpportunitySplash
frmOpportunitySplash.Show vbModeless

I have a background color and some text on the splash screen, but when it is
present, the form appears blank. The code processes "behind" the splash
screen, but can you provide any insight as to why it is blank? I was not
aware of the "vbModeless" code, so perhaps a property or something needs to
be changed accordingly (just a gues on my part).

Any and All Help is Appreciated

Thanks Again
"GS" wrote:

The article Norman directed you to is really great, but it doesn't facilitate
your need for other code to run while the form is displayed. To do so, use
this to display it:

SplashScreen.Show vbModeless

You may want to unload it at the end of your procedure, or move the OnTime
statement there instead of using the form's _Activate event. This will allow
the form to display while the code runs, and dismiss after the procedure
ends, at the specified interval.

Regards, GS

"MWS" wrote:

Thank You Norman for the Response. I did read the article, but won't have the
opportunity to try it right away, but I will. Just a quick question on the
subject:

While the splash screen is being displayed, will the code still execute? I
may have missed this in the article, but want to determine if this approach
will work for me.

Thanks Again

"Norman Jones" wrote:

Hi MWS,

See xlDynamic at:

http://www.xldynamic.com/source/xld.xlFAQ0007.html

---
Regards,
Norman

"MWS" wrote in message
...
Can someone tell me the code to present a splash screen, for approximatey
5
seconds, and then have it unload?

I tried to LOAD my designed form and then SHOW it, but this method does
not
seem to be working, since none of the remaining code executes until I
manually remove the form. My goal is to have the user view the splash
screen,
instead of viewing the excel screen while the data is being, moved,
calcualed
upon and reformatted.

Any and All Help Will Be Appreciated - Thank You!!!!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Splash Screen	John Calder	New Users to Excel	2	May 11th 09 03:22 AM
Splash Screen	Bill[_30_]	Excel Programming	2	November 3rd 05 05:28 PM
Splash screen and various screen resolutions	George J	Excel Programming	4	October 3rd 04 10:15 PM
Splash Screen	Lee	Excel Programming	0	December 1st 03 05:08 PM
VBA splash screen	scott[_6_]	Excel Programming	2	October 16th 03 09:27 AM

Menu

About Us