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

Show progress in a user form while code runs
 

did you try DoEvents

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