What it does
Core purpose
Extends the default VBA(/VB6) collection with methods to retrieve and check for key existence.
Where it sits
CollectionEx belongs to the Dictionary 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 vbforums.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 CollectionEx when your automation needs Dictionary 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 CollectionEx, browse the other entries in the same Dictionary 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.