View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default 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