Show progress in a user form while code runs

[Bura Tino]

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

 

[Guest]

did you try DoEvents

 

[Robin Hammond]

Bura,

Stick a DoEvents statement after the line that updates the caption on the
form.

Robin Hammond
www.enhanceddatasystems.com