VBA Auto Executor
Sometimes when you need to execute a task every period of time and there's no straight predefined function that you can just call and use with a few lines of codes. You will actually need to implement your own module.
I've written this nice class module sometime ago and I believe it will be useful for other VB/VBA developer out there. This class is an Auto Executor, it will automatically call and run a defined Routine.
It will solve the problem in the scenario above and it is written in an object oriented style which you can just embedded the whole class in your project and when you need to use it, just create the instance of it then call the public sub routine to perform the task.
Amazon

