Problem with Splash Screen user form with updating status

  • Thread starter Thread starter professorplum101
  • Start date Start date
P

professorplum101

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
 
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)
 
I got it, but to anyone else who is curious, UserFormName.repaint will
do the trick.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splash Screen Behavior 2
Splash Screen / userform 1
Splash Screen Problem 1
Momentarily Display Splash Screen 9
Splash screen 4
Splash Screen 2
Splash 4
Coding a splash screen to require macros enabled 1

Back
Top