L
Libby
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.
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.