Visual Basic for Applications (VBA) is an implementation of Microsoft’s event-driven programming language Visual Basic 6.0 (VB6) built into most desktop Microsoft Office applications.
This is a curated list of Libraries and Resources for both VBA and VB6.
Because of the nature of VBA, many libraries do not work on all Operating Systems, in all Office Applications or on all architectures(x64/x86), therefore we use symbology. Read more about this here.
stdVBA -
A framework containing numerous classes for automation and utility.
Focuses on code compactness and long-term maintainability.
VbCorLib - A
framework which brings many powerful .NET classes to VBA/VB6.
Hidennotare - A
framework by Japanese author RelaxTools. Contains numerous classes,
interfaces and forms. 
VBA-FastJSON -
Fast, cross-platform, native json parser and serializer. Memory
efficient (non-recursive), RFC 8259 compliant, UTF8 support 
VBA-JSON - JSON
conversion and parsing.
mdJSON
- JSON library with dot-notation for extracting paths.
JSONBag
- Uses shebang notation to extract keys from JSON strings. Can also
build JSON with this library.
In stdVBA find
stdJSON - As above. 
VBA-CSV-interface
- Powerful, fast and comprehensive RFC-4180 compliant CSV/TSV/DSV data
management library.
In Hidennotare
find csvWriter and csvReader. 
VBA-XML - XML conversion
and parsing.
Excel-ZipTools
- Parse, read, and extract data from, Zip files. Written in pure
vba.
vbaSquash
- 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. 
vbaPDF - VBA code for
simple modification of PDF files (read in, combine, write out). 
Better
array - An array class providing features found in more modern
languages.
In
VbCorLib find ArrayList - As above.
In stdVBA find
stdArray - As above. Also includes methods to search the
array or perform checks from a callback. 
VBA-FastDictionary
- Fast, cross-platform, native Dictionary. Replacement for scripting
dictionary. 
VBA-Dictionary -
A dictionary object which stores key-value pairs.
VBA-ExtendedDictionary
- A dictionary object using Scripting.Dictionary but exposes some
additional useful functionality. cHashList
- Simple, Fast and lightweight HashList class with no use of Win32 API.
Requires string keys however.
CollectionEx
- Extends the default VBA(/VB6) collection with methods to retrieve and
check for key existence.
clsTrickHashTable
- A hash table using machine code injected at runtime. Full replacement
for scripting dictionary, with bonus features.
In
VbCorLib find HashTable - As above.
VBA-Math-Objects
- A matrix and vector library. 
VBA
Float - An utility to perform computations over big integers and
rational numbers with thousands digits.
SQL Library - An
OOP SQL Library for psql, mssql, mysql databases.
Task Dialog - 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.
ucSimplePlayer -
Simple video player user control.
ucWebView2 - WebView2
user control.
ucAniGifEx - Animated
GIF user control.
Material UI -
Make your userform feel modern with Material UI. 
Easy
EventListener - Consolidate all event handling of a userform into 1
callback.
Pseudo
Control Arrays - Optimal means of Consolidating all event handling
of a userform. Demonstrates usage of
ConnectToConnectionPoint API. Also worth looking at this
class too.
Modern UI
Components - Custom modern looking controls.
MVVM -
Model-View-ViewModel Infrastructure for maintainable userform
development.
VBA Userform
Transitions and Animations - An excellent library for implementing
animation easings into the Userform.
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.
VBA-SafeTimer -
Reliable, no-crash timer for VBA. Code can be debugged and stopped
safely. Works with or without a form.
Drag
and Drop filepaths - Allow your userform to handle drag-and-drop
files.
Late-bound
WebBrowser Control Events - A technique to latch onto WebBrowser
events in a late-bound manner.
Mark’s
userform tools - Numerous UI tools and pretty userforms.
VBA-UserForm-MouseScroll
- Allows Mouse Wheel Scrolling on MSForms Controls and Userforms. MSForms (Pure VBA)
Treeview Control - A treeview control replacement by JKP and Peter
Thornton coded entirely in VBA. MSForms
(Pure VBA) ListBox Control - Featured in this video. It
has tons of useful features like sorting, filtering, single or
multi-selection with select and deselect all, page navigation and hover
highlight,
Custom
Userform TitleBar color
Multi-color
ListBox class
Use of
GDIPlus in VBA - GDIPlus can be used to create a canvas
like element where any image can be drawn to. Additionally check out
this GDI32
class from the same author.
Use
of OpenGL in VBA - OpenGL is a cross-language, cross-platform
application programming interface for rendering 2D and 3D vector
graphics. In this article the authors of the GDIPlus class.
VB6
Graph Control - Won’t work natively in VBA without a
PictureBox compatible substitute, but an extremely
performant graph control regardless. 
VBA-MemoryTools
- Provides an ultra-fast, copy memory alternative.
Safe
Subclassing - Provides the ability to subclass Excel/Word/PowerPoint
window or Userforms to perform further automation. In the later threads
there is also an example for subclassing other windows from other
applications.
Calling private
module functions - You can also check out Greedo’s
code review.
Universal
DLL Calls - A library which can be used to call functions of any
function pointer, DLL or object in both STDCALL and
CDECL.
vbInvoke -
Application.Run but COM based and can call private module
methods. 
VBA
state-loss callback - 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.
vb2clr
- Use C# from VBA using the .NET CLR runtime.
In stdVBA find
stdCOM - A one stop shop for COM automation, from invoking
interfaces by offsets to extracting type information.
In stdVBA find
stdReg - Registry automation from searching to setting
values.
vba-regex - A native
regex expression parser and runtime engine.
VbPeg - A
parser generator for VBA. Converts PEG grammar like this
into VBA
code like this. Very useful if your implementing a new programming
language in VBA. Wqweto has also included some math expression parsers
as tests. Volpi’s
Math Expression Parser - A fast math expression parser. Doesn’t
allow calls to objects, no callstack. 
VBA Expressions
- A powerful string expression evaluator focussed on mathematics and
data processing.
ClooWrapperVBA -
Execute OpenCL from VBA, using either the GPU or CPU.
In stdVBA find
stdLambda - Full programming language including object
manipulation, call stack, etc. 
VBA-Web - Connect VBA,
Excel, Access, and Office for Windows and Mac to web services and the
web. 
VBA-WebSocket -
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.
vbAsyncSocket -
Simple and thin WinSock API wrappers for VB6 loosely based on the
original CAsyncSocket wrapper in MFC.
Edge
Automation - Automate Chromium Edge using devtools protocol. GitHub
backup here.
Chrome
Automation (via devtools protocol) - Automate Chrome using chrome
devtools protocol.
SeleniumVBA - 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.
webxcel - A webserver
which runs a RESTful backend. The creator also made an article
on how it works on dev.to.
In stdVBA find
stdHTTP - Connect to and query web services.
Rubberduck
- An open-source COM add-in project that integrates with the Visual
Basic Editor to add modern-day features to the familiar IDE. Works in
VBA6, VBA7.x (x86/x64), and yes, in VB6 too!
VBA-IDE-Code-Export
- Addin contains a code importer and exporter for use with git (or any
VCS).
- RibbonX -
AndyPope’s Visual Ribbon Editor.
Custom UI
XML Editor - Addin for directly adding, editing and validating
ribbon XML (Excel 2010+).
MZ-Tools -
VBE addin providing development tools.
VbPeg - 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.
VBA
Resource File Editor - Store other files inside your
excel/word/powerpoint files for later use with this handy tool.
vbRichClient - An
external client full of useful libraries.
vbWatchDog -
vbWatchdog hacks the VBA runtime to provide module name,
procedure name and line number where error occurred.
DLL
Function Viewer - Allows the export of function names from
DLLs.
Accessibility
Inspector - An inspector/explorer for accessibility in applications.
Useful for automation.
Running
Object Table Inspector - An inspector for the running object table
(ROT), a table of global running COM objects which can be obtained.
Clipboard
Inspector - Allows inspection of data held in the clipboard. Useful
for reverse engineering clipboard usage in other applications.
Registry
Inspector - Allows inspection of the win32 registry. Equivalent of
regedit basically, but implemented entirely in VBA.
JSON
Inspector - An inspector for JSON data, can be called on demand too
as a dev tool for inspecting API responses.
Drag
and drop control - Dragging and dropping image controls around a
userform.
EZPZMouseController
- An example of using native Microsoft Ink Collector to detect mouse
wheel and mouse move events.
Iterating
the ROT - An example of iterating the Running Object Table (ROT) to
find Excel Workbook instances.
Iterating
Excel Instances via IAccessible - In some cases Excel instances
aren’t registered to the ROT. The Excel application however implements
IAccessible, which not only can be used to automate the UI,
but can also be used to obtain the Excel Instance from a hwnd.
Excel
Screen Reader - Not only an example of UI Automation, but also an
example of using SAPI to do text to speech.
MenuRighter -
MenuRighter is an Excel addin that lets you modify right-click menus.
You can add almost any control found in other right-click menus or Excel
2003’s “classic” menus.
Sam Rad’s
DatePicker - Visually impressive and professional DatePicker addin
for Excel. Worksheet only / cannot be used with userforms. Excel Name Manager
- An enhanced Name Manager replacement by JKP, Charles Williams and
Matthew Henson. 2025 Finalist in the Best Microsoft Excel Add-In
category. Excel
Flex Find - An enhanced Find-And-Replace replacement by JKP that
exends the search scope to objects and VBA code. 
Word
VBA Syntax Highlighter - Custom built Syntax Highlight tool for Word
Documents.
xlStudio - A
DAW for Microsoft Excel. Also check out the awesome video.
Cellivization - A cool
RTS-like game created in Excel. Also check out the awesome video.
Arkanoid
- Arkanoid, a retro arcade game, built in Excel. On some machines it
runs faster than others.
Battleships
Pacman
ExcelCommodroid
- Commodore computer loader using MS Excel on Windows. VBA7 only. 
oletools - Python tool
which can be used to decode VBA P-Code (VBA’s intermediate
language). twinBasic - A VBA compatible parser,
evaluator and compiler. 
vscode-vba -
Extension that adds VBA editor support to Visual Studio Code. 
VBA
Pro - VSCode Extension that adds enhanced VBA support based on
Language Service Protocol. The source is also on GitHub. 
VBA Build - Github
action to automatically build a VBA project on commit. 
VBA Project Compiler - 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.IDispatch, Variant,
For each and With. It also discusses the
dreaded Date bug ported to Excel from Lotus 123.Хакер. Details the
composition of the VB6 and VBA dlls in amongst the history of the
language.Хакер which estimates the number of lines of code in
VB6/VBA.
Slipstick -
Website of Diane Poremsky (MVP) with focus on Outlook and VBA. TechnicLee - Outlook blog,
many examples including code variations depending on user request.
PowerPoint VBA - A site devoted to
teaching VBA through making games in PowerPoint. No Longer Set -
Access + VBA site of Microsoft MVP Mike Wolfe. Provides weekly updates
on development of TwinBasic. Isladogs on
Access - Access + VBA site of Microsoft MVP Colin Riddington.
Excellent resource with VBA projects in Access VBA. DevHut - Access
+ VBA site of Daniel Pineault. Publishes series of deep-dive articles
into various uses of VBA. Companion site to Youtube account. Excel
VBA Programming For Dummies - It′s time to move to the next
level—creating your own, customized Excel 2010 solutions using Visual
Basic for Applications (VBA).Using step–by–step instruction and the
accessible, friendly For Dummies style, this practical book shows you
how to use VBA, write macros, customize your Excel apps to look and work
the way you want, avoid errors, and more. Power
Programming with VBA - Excel 2019 Power Programming with VBA is
fully updated to cover all the latest tools and tricks of Excel 2019.
Encompassing an analysis of Excel application development and a complete
introduction to Visual Basic for Applications (VBA), this comprehensive
book presents all of the techniques you need to develop both large and
small Excel applications. VBA A2Z - Many tutorials,
some paid content. Good array of interesting and different topics -
in-depth tutorials into different parts of VBA, with some .NET/VSTO
videos. Strong focus on UI development. Get to know VBA - Some great
applications presented and created with VBA. D
Pineault - Tech, Programming and more - Youtube channel of Daniel
Pineault. Companion channel to DevHut site. Slipstick - Excellent forum
for the Slipstick website (Outlook VBA) of Diane Poremsky (MVP). Diane
is quick to respond, and her answers are extremely helpful. Access
World - Forum with focus on Access and Access VBA.Because of the nature of VBA, many libraries do not work on all Operating Systems, in all Office Applications or in all architectures(x64/x86). Some libraries may also require external resources (DLL, Addins, etc.) which can be difficult to use due to VBA’s lack of a package manager. To help you in finding projects suitable for your needs, this awesome list uses the following symbology. The symbology also has tooltips which may provide more information.
-
Available on all platforms
- Available on Windows OS only -
Available on Mac OS only - All applications - Word - Excel - Access - Outlook - PowerPoint - Miscellaneous applications (MS Project, AutoCAD,
etc.) - Specify in short description - 32-bit only - Written in VBA
but the code is password protected - Requires
external dependencies e.g. .dll, .ocx,
.o, etc. - Requires
installation - Link includes/leads to
paid contentYour contributions are always welcome! Please take a look at the contribution guidelines first.