VBA
An event-driven version of Visual Basic 6.0 built into most Microsoft Office apps for automation and scripting.
Contents
Library Collections
A framework containing numerous classes for automation and utility. Focuses on code compactness and long-term maintainability.
A framework which brings many powerful .NET classes to VBA/VB6.
A framework by Japanese author RelaxTools. Contains numerous classes, interfaces and forms.
Libraries
Embedded programming languages
Complete scripting platform with JavaScript-like syntax, native Office ecosystem integration, classes with inheritance, professional debugging, zero dependencies, and VS Code extension.
Use C# from VBA using the .NET CLR runtime.
A powerful string expression evaluator focussed on mathematics and data processing.
ZIP
Parse, read, and extract data from, Zip files. Written in pure vba.
Compress and decompress files and byte arrays using the built-in cabinet.dll functions available on Windows 8+. Provides access to compression algorithms MSZIP, XPRESS, XPRESS_HUFF, and LZMS.
Data Structures
An array class providing features found in more modern languages.
Fast, cross-platform, native Dictionary. Replacement for scripting dictionary.
A dictionary object which stores key-value pairs.
A dictionary object using Scripting.Dictionary but exposes some additional useful functionality.
Math libraries
Userform tools
A huge amount of UI functionality from this 1 class, in a strictly dynamic and modular way. Great for data input forms. Also see vbforums post for more information.
Simple video player user control.
WebView2 user control.
Animated GIF user control.
Make your userform feel modern with Material UI.
Consolidate all event handling of a userform into 1 callback.
Custom modern looking controls.
Model-View-ViewModel Infrastructure for maintainable userform development.
An excellent library for implementing animation easings into the Userform.
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.
Reliable, no-crash timer for VBA. Code can be debugged and stopped safely. Works with or without a form.
Allows Mouse Wheel Scrolling on MSForms Controls and Userforms.
A lightweight wrapper that exposes Microsoft Edge WebView2 on a UserForm, enabling HTML/JS UI, rendering, and two‑way communication with VBA. Effectively replaces the WebBrowser control.
Low level tools
Provides an ultra-fast, copy memory alternative.
Application.Run but COM based and can call private module methods.
A crash free detector for VBA state-loss. State loss can occur when: Someone clicks end in an unhandled error; You click the VBA stop button; You enter design mode; Application exits.
A library for retrieving VBA callstack information at runtime from Office applications. The author also made a pure VBA native version.
Parsers / Interpreters
Web tools
Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web.
Microsoft example code for a WebSocket client which can be used in conjunction with an echo server. There is also a class and an async version built by the discoverer of the microsoft code.
Simple and thin WinSock API wrappers for VB6 loosely based on the original CAsyncSocket wrapper in MFC.
Automate Chrome using chrome devtools protocol.
Drive selenium webdriver directly from VBA. If you don't have the driver installed, the library will attempt to download it for you and run it. However AV may restrict the running of this process.
A webserver which runs a RESTful backend. The creator also made an article on how it works on dev.to.
Developer tools
A parser generator for VBA. Converts PEG grammar like this into VBA code like this. Very useful if you're implementing a new programming language in VBA.
Addin contains a code importer and exporter for use with git (or any VCS).
A pure-VBA class that reads, inspects, and exports VBA source code directly from Office binary files
Examples
Games / Fun projects
External tools
Python tool which can be used to decode VBA P-Code (VBA's intermediate language).
Extension that adds VBA editor support to Visual Studio Code.
VSCode Extension that adds enhanced VBA support based on Language Service Protocol. The source is also on GitHub.
Github action to automatically build a VBA project on commit.
A python library which can be utilised to compile VBA projects. There is also a built-in Excel addin generator made by the same author! You can see a list of related projects by the author here.