extension
jkp-ads.com
Excel Flex Find
An enhanced Find-And-Replace replacement by JKP that exends the search scope to objects and VBA code.
VBA Tools Directory
166 community-curated libraries for Microsoft Office automation — JSON parsers, data structures, databases, UI toolkits, low-level Win32 helpers, and more. Each entry links to the maintainer’s open-source repository.
AddIns
5 tools
extension
jkp-ads.com
Excel Name Manager
An enhanced Name Manager replacement by JKP, Charles Williams and Matthew Henson. 2025 Finalist in the Best Microsoft Excel Add-In…
extension
yoursumbuddy.com
MenuRighter
MenuRighter is an Excel addin that lets you modify right-click menus. You can add almost any control found in other…
extension
samradapps.com
Sam Rad's DatePicker
Visually impressive and professional DatePicker addin for Excel. Worksheet only / cannot be used with userforms.
extension
github.com
Word VBA Syntax Highlighter
Custom built Syntax Highlight tool for Word Documents.
Algorithms, code optimisation, and performance testing
1 tool
extension
xbeat.net
VBSpeed
The Visual Basic Performance Site - focus on VB6 but transferrable across to VBA.
Array-List
1 tool
extension
github.com
Better array
An array class providing features found in more modern languages.
Books
8 tools
extension
goalkicker.com
(E-Book) Excel VBA beginners
Direct Answer (E-Book) Excel VBA beginners is a Books library for Microsoft Office automation. Hosted at goalkicker.com. What it does…
extension
goalkicker.com
(E-Book) VBA beginners
Direct Answer (E-Book) VBA beginners is a Books library for Microsoft Office automation. Hosted at goalkicker.com. What it does Core…
extension
pdfcoffee.com
Advanced Visual Basic 6
Power Techniques for Everyday Programs Matthew Curland. Hardbacks also available elsewhere.
extension
google.com
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…
extension
classicvb.net
Hard Core Visual Basic
An advanced programmer's guide to the new 5.0 version of Visual Basic. Includes a core set of utilities, shortcuts, and…
extension
wiley.com
Power Programming with VBA
Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019.…
extension
oiipdf.com
Professional Excel Development
In this book, four world-class Microsoft® Excel developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel.…
extension
academia.edu
The VBA Developer's Handbook
Write bulletproof VBA code for any situation. This book is the essential resource for developers working with any of the…
CSV
1 tool
extension
github.com
VBA-CSV-interface
Powerful, fast and comprehensive RFC-4180 compliant CSV/TSV/DSV data management library.
Database tools
1 tool
extension
github.com
SQL Library
An OOP SQL Library for psql, mssql, mysql databases.
Developer tools
17 tools
extension
github.com
Accessibility Inspector
An inspector/explorer for accessibility in applications. Useful for automation.
extension
github.com
Clipboard Inspector
Allows inspection of data held in the clipboard. Useful for reverse engineering clipboard usage in other applications.
extension
yoursumbuddy.com
Custom UI XML Editor
Addin for directly adding, editing and validating ribbon XML (Excel 2010+).
extension
mrexcel.com
DLL Function Viewer
Allows the export of function names from DLLs.
extension
github.com
JSON Inspector
An inspector for JSON data, can be called on demand too as a dev tool for inspecting API responses.
extension
mztools.com
MZ-Tools
VBE addin providing development tools.
extension
github.com
Registry Inspector
Allows inspection of the win32 registry. Equivalent of regedit basically, but implemented entirely in VBA.
extension
ribboncreator2021.de
Ribbon Creator
An excellent and intuitive WYSIWYG interface for the development of ribbons. The free shareware version allows for the export of…
extension
andypope.info
RibbonX
AndyPope's Visual Ribbon Editor.
extension
rubberduckvba.com
Rubberduck
An open-source COM add-in project that integrates with the Visual Basic Editor to add modern-day features to the familiar IDE.…
extension
github.com
Running Object Table Inspector
An inspector for the running object table (ROT), a table of global running COM objects which can be obtained.
extension
leandroascierto.com
VBA Resource File Editor
Store other files inside your excel/word/powerpoint files for later use with this handy tool.
extension
github.com
VBA-IDE-Code-Export
Addin contains a code importer and exporter for use with git (or any VCS).
extension
github.com
vbaXray
A pure-VBA class that reads, inspects, and exports VBA source code directly from Office binary files
extension
github.com
VbPeg
A parser generator for VBA. Converts PEG grammar like [this](https://github.com/wqweto/VbPeg/blob/master/test/Runner/peg/Kscope/grammar.peg) into [VBA code like this](https://github.com/wqweto/VbPeg/blob/master/test/Runner/peg/Kscope/cKscope.cls). Very useful if you're implementing…
extension
vbrichclient.com
vbRichClient
An external client full of useful libraries.
extension
everythingaccess.com
vbWatchDog
`vbWatchdog` hacks the VBA runtime to provide module name, procedure name and line number where error occurred.
Dictionary
6 tools
extension
vbforums.com
cHashList
) - Simple, Fast and lightweight HashList class with no use of Win32 API. Requires string keys however.
extension
vbforums.com
clsTrickHashTable
A hash table using machine code injected at runtime. Full replacement for scripting dictionary, with bonus features.
extension
vbforums.com
CollectionEx
Extends the default VBA(/VB6) collection with methods to retrieve and check for key existence.
extension
github.com
VBA-Dictionary
A dictionary object which stores key-value pairs.
extension
github.com
VBA-ExtendedDictionary
A dictionary object using Scripting.Dictionary but exposes some additional useful functionality.
extension
github.com
VBA-FastDictionary
Fast, cross-platform, native Dictionary. Replacement for scripting dictionary.
Embedded programming languages
3 tools
extension
github.com
Advanced Scripting Framework (ASF)
Complete scripting platform with JavaScript-like syntax, native Office ecosystem integration, classes with inheritance, professional debugging, zero dependencies, and VS Code…
extension
github.com
vb2clr
Use C# from VBA using the .NET CLR runtime.
extension
github.com
VBA Expressions
A powerful string expression evaluator focussed on mathematics and data processing.
External tools
7 tools
extension
github.com
oletools
Python tool which can be used to decode VBA P-Code (VBA's intermediate language).
extension
twinbasic.com
twinBasic
A VBA compatible parser, evaluator and compiler.
extension
github.com
VBA Build
Github action to automatically build a VBA project on commit.
extension
marketplace.visualstudio.com
VBA Pro
VSCode Extension that adds enhanced VBA support based on Language Service Protocol. The source is also [on GitHub](https://github.com/SSlinky/VBA-LanguageServer).
extension
github.com
VBA Project Compiler
A python library which can be utilised to compile VBA projects. There is also a built-in [Excel addin generator](https://github.com/Beakerboy/Excel-Addin-Generator) made…
extension
github.com
vscode-vba
Extension that adds VBA editor support to Visual Studio Code.
extension
winvba.com
WinVBA
A modern IDE for Visual Basic for Applications (VBA) development.
Forums
10 tools
extension
access-programmers.co.uk
Access World
Forum with focus on Access and Access VBA.
extension
chandoo.org
Chandoo
Forum for the Chandoo - the blog of Purna Duggirala (MVP). Very active.
extension
discord.gg
Excel Discord
Discord server moderated by Tim Heng (Excel MVP) with focus on helping Excel users.
extension
excelforum.com
Excel Forum
Direct Answer Excel Forum is a Forums library for Microsoft Office automation. Hosted at excelforum.com. What it does Core purpose…
extension
mrexcel.com
MrExcel
Mostly Excel generic, but a lot of VBA content can be found here also.
extension
reddit.co.uk
Daily VBA Q&A. Occasional Pro-Tip sharing and Show & Tell library publishing.
extension
forums.slipstick.com
Slipstick
Excellent forum for the Slipstick website (Outlook VBA) of Diane Poremsky (MVP). Diane is quick to respond, and her answers…
extension
stackoverflow.com
Stack Overflow
A great place to ask questions. Duplicate questions are flagged as duplicates and send the author to the correct place.
extension
vbforums.com
VBForums - Office Development
Forum with focus on VB6/.NET with VBA section.
extension
discord.gg
Visual Basic Discord
A chat room for VB.NET/VBA/VB6 fanatics.
Games / Fun projects
7 tools
extension
leandroascierto.com
Arkanoid
Arkanoid, a retro arcade game, built in Excel. On some machines it runs faster than others.
extension
github.com
Battleships
Direct Answer Battleships is a Games / Fun projects library for Microsoft Office automation. Hosted at github.com. What it does…
extension
s0lly.itch.io
Cellivization
A cool RTS-like game created in Excel. Also check out the awesome [video](https://www.youtube.com/watch?v=PzETBRcr_i8).
extension
github.com
ExcelCommodroid
Commodore computer loader using MS Excel on Windows. VBA7 only.
extension
github.com
M2000Interpreter
Direct Answer M2000Interpreter is a Games / Fun projects library for Microsoft Office automation. Hosted at github.com. What it does…
extension
arkham46.developpez.com
Pacman
Direct Answer Pacman is a Games / Fun projects library for Microsoft Office automation. Hosted at arkham46.developpez.com. What it does…
extension
github.com
xlStudio
A DAW for Microsoft Excel. Also check out the awesome [video](https://youtu.be/RFdCM2kHL64).
Information
7 tools
extension
sancarn.github.io
Articles by Sancarn
Various articles written by Sancarn about VBA including, performance, actual issues with VBA etc.
extension
bbs.vbstreets.ru
How many lines of code in EB
Untranlated article by Russian VBer `Хакер` which estimates the number of lines of code in VB6/VBA.
extension
joelonsoftware.com
My First Bill Gates Review
Joel Spolsky, program manager for the Excel team, recounts his first Bill Gates review. Joel got numerous features added e.g.…
extension
vbforums.com
PCode Internals
VBA is compiled to PCode. Understanding the lower level P-Code is a topic of heavy interest and research.
extension
github.com
Ruby, EB and DLL composition
Translated copy of [VBStreets article](http://bbs.vbstreets.ru/viewtopic.php?f=101&t=56551) created by Russian VBer `Хакер`. Details the composition of the VB6 and VBA dlls in…
extension
vbforums.com
SAFEARRAYS
The internal structure of arrays.
extension
forestmoon.com
Thunder - The birth of Visual Basic
A little article about the birth of VB7/VBA.
JSON
3 tools
extension
vbforums.com
JSONBag
Uses shebang notation to extract keys from JSON strings. Can also build JSON with this library.
extension
vbforums.com
mdJSON
JSON library with dot-notation for extracting paths.
extension
github.com
VBA-FastJSON
Fast, cross-platform, native json parser and serializer. Memory efficient (non-recursive), RFC 8259 compliant, UTF8 support
Library Collections
3 tools
extension
github.com
Hidennotare
A framework by Japanese author RelaxTools. Contains numerous classes, interfaces and forms.
extension
github.com
stdVBA
A framework containing numerous classes for automation and utility. Focuses on code compactness and long-term maintainability.
extension
github.com
VbCorLib
A framework which brings many powerful .NET classes to VBA/VB6.
Low level examples
3 tools
extension
mrexcel.com
Excel Screen Reader
Not only an example of UI Automation, but also an example of using SAPI to do text to speech.
extension
mrexcel.com
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…
extension
mrexcel.com
Iterating the ROT
An example of iterating the Running Object Table (ROT) to find Excel Workbook instances.
Low level tools
7 tools
extension
github.com
Calling private module functions
You can also check out [Greedo's code review](https://codereview.stackexchange.com/questions/274532/low-level-vba-hacking-making-private-functions-public).
extension
mrexcel.com
Safe Subclassing
Provides the ability to subclass Excel/Word/PowerPoint window or Userforms to perform further automation. In the later threads there is also…
extension
vbforums.com
Universal DLL Calls
) - A library which can be used to call functions of any function pointer, DLL or object in both…
extension
github.com
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…
extension
github.com
VBA-MemoryTools
Provides an ultra-fast, copy memory alternative.
extension
github.com
VBAStack
A library for retrieving VBA callstack information at runtime from Office applications. The author also made a [pure VBA native…
extension
github.com
vbInvoke
`Application.Run` but COM based and can call private module methods.
Math libraries
2 tools
extension
github.com
VBA Float
An utility to perform computations over big integers and rational numbers with thousands digits.
extension
github.com
VBA-Math-Objects
A matrix and vector library.
extension
github.com
vbaPDF
VBA code for simple modification of PDF files (read in, combine, write out).
Parsers / Interpreters
3 tools
extension
github.com
ClooWrapperVBA
Execute OpenCL from VBA, using either the GPU or CPU.
extension
github.com
vba-regex
A native regex expression parser and runtime engine.
extension
web.archive.org
Volpi's Math Expression Parser
A fast math expression parser. Doesn't allow calls to objects, no callstack.
Style Guides
2 tools
extension
rubberduckvba.wordpress.com
RubberDuck's style guide
Has some great intermediate - advanced guidance.
extension
docs.microsoft.com
VB6 Coding conventions
) - Variable/Class/Module naming conventions used in VBA. Greatly helps organisation in VBE (unless you have rubberduck).
UI Ribbon
3 tools
extension
accessribbon.de
Access Ribbon
An excellent resource for information for developing custom ribbon XML. Although principally targeted at Access, it is equally applicable to…
extension
spreadsheet1.com
Office MSO Icons
Ribbon icons can often use one of the 1500 (3 pages on this site) MSO icons wich pre-exist in Office…
extension
jkp-ads.com
Ron de Bruin - Ribbons/QAT
A leading resource for information/samples on developing custom ribbons and context menus. (Hosted on Jan Karel Pieterse's site)
UI Userforms
2 tools
extension
vbforums.com
Drag and drop control
Dragging and dropping image controls around a userform.
extension
github.com
EZPZMouseController
An example of using native Microsoft Ink Collector to detect mouse wheel and mouse move events.
Userform tools
24 tools
extension
mrexcel.com
Custom Userform TitleBar color
Direct Answer Custom Userform TitleBar color is a Userform tools library for Microsoft Office automation. Hosted at mrexcel.com. What it…
extension
mrexcel.com
Drag and Drop filepaths
Allow your userform to handle drag-and-drop files.
extension
github.com
Easy EventListener
Consolidate all event handling of a userform into 1 callback.
extension
vbforums.com
Late-bound WebBrowser Control Events
A technique to latch onto WebBrowser events in a late-bound manner.
extension
kubiszyn.co.uk
Mark's userform tools
Numerous UI tools and pretty userforms.
extension
github.com
Material UI
Make your userform feel modern with Material UI.
extension
github.com
Modern UI Components
Custom modern looking controls.
extension
app.monstercampaigns.com
MSForms (Pure VBA) ListBox Control
Featured in [this video](https://www.youtube.com/watch?v=QYW1SlKfKdM). It has tons of useful features like sorting, filtering, single or multi-selection with select and deselect…
extension
jkp-ads.com
MSForms (Pure VBA) Treeview Control
A treeview control replacement by JKP and Peter Thornton coded entirely in VBA.
extension
mrexcel.com
Multi-color ListBox class
Direct Answer Multi-color ListBox class is a Userform tools library for Microsoft Office automation. Hosted at mrexcel.com. What it does…
extension
github.com
MVVM
Model-View-ViewModel Infrastructure for maintainable userform development.
extension
addinbox.sakura.ne.jp
Pseudo Control Arrays
Optimal means of Consolidating all event handling of a userform. Demonstrates usage of `ConnectToConnectionPoint` API. Also worth looking at [this…
extension
github.com
Task Dialog
A huge amount of UI functionality from this 1 class, in a strictly dynamic and modular way. Great for data…
extension
github.com
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…
extension
github.com
ucAniGifEx
Animated GIF user control.
extension
github.com
ucSimplePlayer
Simple video player user control.
extension
github.com
ucWebView2
WebView2 user control.
extension
arkham46.developpez.com
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…
extension
arkham46.developpez.com
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…
extension
vb6awards.blogspot.com
VB6 Graph Control
Won't work natively in VBA without a `PictureBox` compatible substitute, but an extremely performant graph control regardless.
extension
github.com
VBA Userform Transitions and Animations
An excellent library for implementing animation easings into the Userform.
extension
github.com
VBA-SafeTimer
Reliable, no-crash timer for VBA. Code can be debugged and stopped safely. Works with or without a form.
extension
github.com
VBA-UserForm-MouseScroll
Allows Mouse Wheel Scrolling on MSForms Controls and Userforms.
extension
github.com
WebView2 for Excel VBA
– A lightweight wrapper that exposes Microsoft Edge WebView2 on a UserForm, enabling HTML/JS UI, rendering, and two‑way communication with…
VB6 / VBScript
2 tools
extension
github.com
Planet Source Code
A code repository GitHub which holds copious amounts of code. The site was closed down in 2023, but fortunately all…
extension
github.com
vbAccelerator Archive
Archived copy of vbAccelerator site (articles, source code, etc.) that disappeared in 2015, reappeared in 2018, and anyone's guess what's…
Web tools
7 tools
extension
github.com
Chrome Automation (via devtools protocol)
Automate Chrome using chrome devtools protocol.
extension
codeproject.com
Edge Automation
Automate Chromium Edge using devtools protocol. [GitHub backup here](https://github.com/sancarn/stdVBA-Inspiration/tree/master/ChromeEdgeAutomation).
extension
github.com
SeleniumVBA
Drive selenium webdriver directly from VBA. If you don't have the driver installed, the library will attempt to download it…
extension
github.com
VBA-Web
Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web.
extension
github.com
VBA-WebSocket
Microsoft example code for a WebSocket client which can be used in conjunction with an echo server. There is also…
extension
github.com
vbAsyncSocket
Simple and thin WinSock API wrappers for VB6 loosely based on the original CAsyncSocket wrapper in MFC.
extension
github.com
webxcel
A webserver which runs a RESTful backend. The creator also made an [article](https://dev.to/michaelneu/to-vba-and-beyond---building-a-restful-backend-using-plain-microsoft-excel-macros-76n) on how it works on dev.to.
Websites
16 tools
extension
analystcave.com
AnalystCave
A site dedicated to VBA for analytics.
extension
bytecomb.com
Bytecomb VBA Reference
Intermediate-advanced topics.
extension
cpearson.com
Chip Pearson's website
Great resource for beginners-intermediate.
extension
devhut.net
DevHut
Access + VBA site of Daniel Pineault. Publishes series of deep-dive articles into various uses of VBA. Companion site to…
extension
exceldevelopmentplatform.blogspot.com
Excel Development Platform Blog
Blog dealing with advanced topics/VBA.
extension
isladogs.co.uk
Isladogs on Access
Access + VBA site of Microsoft MVP Colin Riddington. Excellent resource with VBA projects in Access VBA.
extension
github.com
MS KB Archive
Massive archive of vb6/vba problems, solutions and tutorials.
extension
docs.microsoft.com
MS-VBAL Language Spec
Direct Answer MS-VBAL Language Spec is a Websites library for Microsoft Office automation. Hosted at docs.microsoft.com. What it does Core…
extension
msdn.microsoft.com
MSDN VBA Documentation
Direct Answer MSDN VBA Documentation is a Websites library for Microsoft Office automation. Hosted at msdn.microsoft.com. What it does Core…
extension
nolongerset.com
No Longer Set
Access + VBA site of Microsoft MVP Mike Wolfe. Provides weekly updates on development of TwinBasic.
extension
pptvba.com
PowerPoint VBA
A site devoted to teaching VBA through making games in PowerPoint.
extension
web.archive.org
Ron de Bruin
Simple-Intermediate topics. Note: Ron has archived all these sites, it will not be updated, and some information is out of…
extension
rubberduckvba.wordpress.com
Rubberduck Blog
Intermediate-Advanced topics.
extension
sancarn.github.io
Sancarn's vba-articles
Sancarn's articles on various topics related to VBA.
extension
techniclee.wordpress.com
TechnicLee
Outlook blog, many examples including code variations depending on user request.
extension
snb-vba.eu
VBA for smarties
A great reference to numerous data structures and mechanics.
Win32 API Resources
2 tools
extension
jkp-ads.com
JKP API Declarations
Direct Answer JKP API Declarations is a Win32 API Resources library for Microsoft Office automation. Hosted at jkp-ads.com. What it…
extension
docs.microsoft.com
Microsoft Office Code Compatibility Inspector
) - The Microsoft Office Code Compatibility Inspector was designed by Microsoft to troubleshoot compatibility issues with VBA code as…
XML
1 tool
extension
github.com
VBA-XML
XML conversion and parsing.
YouTube
9 tools
extension
youtube.com
D Pineault - Tech, Programming and more
Youtube channel of Daniel Pineault. Companion channel to DevHut site.
extension
youtube.com
Excel for Freelancers
Hands-on tutorials to developing specific applications from beginning through to end. All levels.
extension
youtube.com
Excel Macro Mastery
Paul Kelly (MVP) - excelmacromastery.com.
extension
youtube.com
Excel VBA Is Fun
Direct Answer Excel VBA Is Fun is a YouTube library for Microsoft Office automation. Hosted at youtube.com. What it does…
extension
youtu.be
Get to know VBA
Some great applications presented and created with VBA.
extension
youtube.com
Leila Gharani
Office-wide focus - useful for beginners.
extension
youtube.com
Sigma Coding
Large catalogue of tutorials - beginner through to advanced. Delves into interesting areas of VBA not explored by other content…
extension
youtube.com
VBA A2Z
Many tutorials, some paid content. Good array of interesting and different topics - in-depth tutorials into different parts of VBA,…
extension
youtube.com
WiseOwl's VBA tutorials
Great all-round resource for VBA. Perfect introduction for beginners. In-depth lessons into all aspects of VBA. Huge playlist that covers…
ZIP
2 tools
extension
github.com
Excel-ZipTools
Parse, read, and extract data from, Zip files. Written in pure vba.
extension
github.com
vbaSquash
Compress and decompress files and byte arrays using the built-in `cabinet.dll` functions available on Windows 8+. Provides access to compression…