View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Problem with Splash Screen user form with updating status

Checkboxes on the form?

Try adding DoEvents after the update.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
oups.com...
I have a user form that loads at the beginning of a long list of vb
code as a splashscreen (Modal = 0), screen updating, events, and
autocalculations are all off. At certain points during the code,
check boxes are updated with the status of the code. When I step
through this code, line by line, everything works perfectly.
However, when I run the code, the splash screen loads and does not
update until it is closed at the end of the code. I am turning
screenupdating on before each command is sent to the userform and then
off again after. Is there some amount of time required to process
these commands? Can anyone help? Thanks

Brian