Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Transparency of User Form or Splash Screen | Excel Programming | |||
Splash Screen Problem | Excel Programming | |||
Splash Screen problem | Excel Programming | |||
splash screen macro problem | Excel Programming | |||
Splash Screen Problem | Excel Programming |