On screen timer

[DropsIT]

I am running a number of macros that incorporate a lot of processes that often take quite a while to run. I know that we have the progress bar on the bottom of the screen but this only shows the progress of each query as it is run. I would like to be able put some kind of timer / graphic on screen that shows overall progress and something that indicates that the processes are still running,(sometimes the progress bar doesn't change for quite a while and users think that it has stalled !)I would also like to show how long it has taken so far. (I would also like to be able to record the total run time for each macro as well if this is possible).

Has anyone got any ideas ?

Thanks

 

[SkipVought]

Hi,

If you call your macros using a VBA procedure, you could show a VB UserForm, that displays all the information you wish.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]