Userform - indication of activity
 

Hi there,

I'm familiar with creating progress bars and other animation to indicate
something is happening and the computer hasn't crashed.
All these methods require periodic updating of the objects at various stages.

I'm required to search over 100,000 rows and to do this I'm using the

set f = .find(what:=value) code

However there doesn't appear to be a way of updating objects when executing
this code and updating the dimensions of an object without interrupting it
and thus slowing it down.

Is there anyway in vba to have something twirling in the background to
demontrate activity without affecting the performance of this kind of search.

Static objects or the standard windows egg timer are not sufficient as users
are too often unable to tell if the thing has crashed. Consequently they
End-Task the program.

Userform - indication of activity
 

You can try somthing simple lik change the user forms Back color to indicate
progress.

"Libby" wrote:

Hi there,

I'm familiar with creating progress bars and other animation to indicate
something is happening and the computer hasn't crashed.
All these methods require periodic updating of the objects at various stages.

I'm required to search over 100,000 rows and to do this I'm using the

set f = .find(what:=value) code

However there doesn't appear to be a way of updating objects when executing
this code and updating the dimensions of an object without interrupting it
and thus slowing it down.

Is there anyway in vba to have something twirling in the background to
demontrate activity without affecting the performance of this kind of search.

Static objects or the standard windows egg timer are not sufficient as users
are too often unable to tell if the thing has crashed. Consequently they
End-Task the program.