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!!!!

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!!!!

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!!!!

Hi MWS,

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.


The splash screen is unloaded at a fixed time using the OnTime method. This
does not preclude other code from running.

---
Regards,
Norman

hmm.. doen not preclude from running ?

Show your SplashScreen as vbModeless!
(either in designer via properties (ShowModal=false)
or with Show vbModeless

If the userform is Modal then the routine that
shows the form is paused until the form is closed.
(closing by user or with the ontime)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Norman Jones wrote :

Hi MWS,

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.


The splash screen is unloaded at a fixed time using the OnTime
method. This does not preclude other code from running.

---
Regards,
Norman

Thank You "keepITcool". I will try your suggestion, it sounds precisely what
I'm looking for!!!!

"keepITcool" wrote:


hmm.. doen not preclude from running ?

Show your SplashScreen as vbModeless!
(either in designer via properties (ShowModal=false)
or with Show vbModeless

If the userform is Modal then the routine that
shows the form is paused until the form is closed.
(closing by user or with the ontime)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Norman Jones wrote :

Hi MWS,

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.


The splash screen is unloaded at a fixed time using the OnTime
method. This does not preclude other code from running.

---
Regards,
Norman