View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Momentarily Display Splash Screen


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