Userform tools > Trick's Timer

If you need to run a piece of code continuously and don't have access to Application.OnTime (and/or you need to run it faster than once per second), this is the class for you! Also check out the forum post for more information. Limitation: Requires a modal form.