| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show progress in a user form while code runs
Hi,
I have a proc which takes about 15 sec to run and I want to keep the user updated with what's going on. So I show a modeless form and the code keeps executing. However, while that is taking place the form appears to be dead. I want to change to contents of a label on the form: "Now doing A", "Now doing B", "Now doing C", etc, but that seems impossible. The form remains "whited-out". Any suggetions? Thanks! Bura |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show progress in a user form while code runs
did you try DoEvents
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show progress in a user form while code runs
Bura,
Stick a DoEvents statement after the line that updates the caption on the form. Robin Hammond www.enhanceddatasystems.com "Bura Tino" wrote in message om... Hi, I have a proc which takes about 15 sec to run and I want to keep the user updated with what's going on. So I show a modeless form and the code keeps executing. However, while that is taking place the form appears to be dead. I want to change to contents of a label on the form: "Now doing A", "Now doing B", "Now doing C", etc, but that seems impossible. The form remains "whited-out". Any suggetions? Thanks! Bura |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show user form | Links and Linking in Excel | |||
| User Form Code | New Users to Excel | |||
| Removing a user form with code | Excel Programming | |||
| Show user form | Excel Programming | |||
| Only Show User Form Once | Excel Programming | |||
Linear Mode
