Problem with Splash Screen user form with updating status
 

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

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

Problem with Splash Screen user form with updating status
 

I got it, but to anyone else who is curious, UserFormName.repaint will
do the trick.