Using Application.OnTime as a progress bar on screen

[chuckchuckit]

Am wondering what kind of hidden problems may be encountered if doing the following:

Using "Application.OnTime" every few seconds to launch a small macro that will be used as a time status bar updating the screen with a bar length that changes.

It will draw a different length on screen every few seconds to show time duration etc. It will then call another "Application.OnTime" set to run the macro again a few seconds later for the next screen status update.

This avoids having a macro run continually that would not allow keyboard use when that macro would be running during the full status bar time involved.

Since this will be calling "Application.OnTime" thousands of times during the day, do I need to do something to clean up after using each "Application.OnTime" or does it clean up after itself and not cause any trouble from my calling it thousands of time automatically?

Thanks.

Chuck

 

[chuckchuckit]

Looks like there is no problem at all calling as many "Application.OnTime" calls as you want. Once they launch themselves, it appears their function is done so no ill effects. Watch Windows Task Manager and Windows Resource Monitor and no memory problems there etc.

Works great for a painting a progress bar on the screen without a constant looping macro.