Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with DoEvents to show progress form, please?
I've got a pretty long-running macro inside a UserForm, and I wanted
to open a second form just to show that things are still working and not crashed. It's pretty simple - four labels and I cycle around turning one at a time a different color. I call it from the main form with Private Sub CommandButton1_Click() DoEvents frmWaiting.Show vbModeless DoEvents Unfortunately, once the code drops into the second form, the main code in the first form never executes. I thought DoEvents was supposed to let the running code "drop through" to allow both forms to run their code. Obviously, I'm very incorrect!! 8( How can I make this happen correctly? Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show download progress to user | Excel Programming | |||
Show progress of copying | Excel Programming | |||
Show an ODBC progress | Excel Programming | |||
Show progress in a user form while code runs | Excel Programming |