extension
Userform tools

Trick’s Timer

Direct Answer

Trick's Timer is a Userform tools library for Microsoft Office automation. 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](https://www.vbforums.com/showthread.php?875635-VB6-VBA-Timer-class) for more information. Limitation: Requires a modal form. Hosted at github.com.

What it does

Core purpose

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](https://www.vbforums.com/showthread.php?875635-VB6-VBA-Timer-class) for more information. Limitation: Requires a modal form.

Where it sits

Trick's Timer belongs to the Userform tools family of VBA community tools. It is listed on the community-maintained awesome-vba index and is actively used by Microsoft Office automation developers.

How to get it

Source location

Full source, documentation, and release notes are maintained at github.com. Treat that URL as the canonical reference — bugs and feature requests live there.

Installation pattern

For a typical GitHub-hosted VBA library: download the .bas, .cls, or .frm files from the repository, then in the VBA editor (Alt + F11) use File → Import File… to bring each module into your project. Save the host document as .xlsm, .accdb, or .docm so macros are retained.

When to use it

Best fit

Reach for Trick's Timer when your automation needs Userform tools capability and you want a peer-reviewed library rather than rolling your own. The awesome-vba curator reviews inclusions for active maintenance and community support.

Alternatives worth evaluating

Before committing to Trick's Timer, browse the other entries in the same Userform tools section of our tools directory — several libraries typically overlap in purpose, and the right pick depends on your Office version, 32- vs 64-bit target, and licensing needs.

Open source

Link goes to the maintainer’s repository; license terms vary per project.


open_in_new
Open on github.com