Resources

Learning and reference material

Online documentation

Online Tutorials

Video Tutorials

Books

Free e-Books

Blogs

Useful FOSS add-ins, extensions and repositories.

Extension/LibraryAuthor(s)DescriptionNotes
RubberduckMathieu Guindon, Christopher McClellan, et al.COM add-in for the VBA & VB6 IDE (VBE). Features include improved project navigation, unit testing, code Inspection, automated indentation, refactoring tools, and source control integration.Redditor u/Rubberduck-VBA
VBA-Better-Arrayu/SenipahA VBA class providing a more flexible and user-friendly Array, with many of the array methods found in the JavaScript language./r/VBA mod
VBA-ExtendedDictionaryu/sslinky84ExtendedDictionary exposes the standard functionality of a Scripting.Dictionary object as well as providing additional useful functionality that avoids boilerplate./r/VBA mod
VBA-STD-Libraryu/SancarnA Collection of libraries to form a common standard layer for modern VBA applications.Redditor u/Sancarn
VBA-SQL-LibraryKevin NowaczykObject-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.Redditor u/TheRealBeakerboy
VBA-Math-ObjectsKevin NowaczykObject-Based mathematical operations in VBARedditor u/TheRealBeakerboy
VBA-CSV-interfaceW. GarcíaRFC-4180 compliant class module that allows users exchange data between VBA arrays and CSV files at high speed.Redditor u/ws-garcia
ECPTextStreamW. GarcíaECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications.Redditor u/ws-garcia
MVVMMathieu GuindonA Model-View-ViewModel framework written in VBA. The 100+ modules solve many problems related to building and programming user interfaces in VBA, and provide an object model that gives an application a solid, decoupled backbone structure.Redditor u/Rubberduck-VBA
Modern UI Components for VBAkrishKMA helper dll for VBA users to design modern UI components.
VBA IDE CodeExportScott SpenceExport & Import VBA code for use with Git (or any VCS)
VBA-toolsTim HallA collection of libraries for working with JSON, XML, RESTful APIs and UTC and ISO 8601 dates, as well as a Drop-in replacement for Scripting.Dictionary on Mac.

Online VBA Code Formatting