An event-driven version of Visual Basic 6.0 built into most Microsoft Office apps for automation and scripting.
Ribbon icons can often use one of the 1500 (3 pages on this site) MSO icons wich pre-exist in Office applications.
A leading resource for information/samples on developing custom ribbons and context menus.
The Visual Basic Performance Site - focus on VB6 but transferrable across to VBA.
Various articles written by Sancarn about VBA including, performance, actual issues with VBA etc.
Untranlated article by Russian VBer `Хакер` which estimates the number of lines of code in VB6/VBA.
Joel Spolsky, program manager for the Excel team, recounts his first Bill Gates review. Joel got numerous features added e.g. `IDispatch`, `Variant`, `For each` and `With`. It also discusses the dreaded Date bug ported to Excel from Lotus 123.
VBA is compiled to PCode. Understanding the lower level P-Code is a topic of heavy interest and research.
Translated copy of VBStreets article created by Russian VBer `Хакер`. Details the composition of the VB6 and VBA dlls in amongst the history of the language.
The internal structure of arrays.
A little article about the birth of VB7/VBA.
Power Techniques for Everyday Programs Matthew Curland. Hardbacks also available elsewhere.
Intermediate-advanced topics.
Forum for the Chandoo - the blog of Purna Duggirala (MVP). Very active.
Great resource for beginners-intermediate.
Blog dealing with advanced topics/VBA.
Discord server moderated by Tim Heng (Excel MVP) with focus on helping Excel users.
Hands-on tutorials to developing specific applications from beginning through to end. All levels.
Paul Kelly (MVP) - excelmacromastery.com.
An advanced programmer's guide to the new 5.0 version of Visual Basic. Includes a core set of utilities, shortcuts, and solutions to problems to achieve a wide range of functional programs. A hard book also exists. Also check out the Comments and corrections.
Office-wide focus - useful for beginners.
) - The Microsoft Office Code Compatibility Inspector was designed by Microsoft to troubleshoot compatibility issues with VBA code as when upgrading Office from 32-bit to 64-bit. MS has not maintained a link to the software for download from its servers, though versions of it are apparently available on the internet.
Mostly Excel generic, but a lot of VBA content can be found here also.
Massive archive of vb6/vba problems, solutions and tutorials.
A code repository GitHub which holds copious amounts of code. The site was closed down in 2023, but fortunately all VBA/VB6 samples were archived on GitHub today. Possibly not the entire collection (?) of projects/source code that was previously available at the PSC website.
In this book, four world-class Microsoft® Excel developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. Hardbacks also available.
Daily VBA Q&A. Occasional Pro-Tip sharing and Show & Tell library publishing.
Simple-Intermediate topics. Note: Ron has archived all these sites, it will not be updated, and some information is out of date, yet it is still an incredible resource for VBA.
Intermediate-Advanced topics.
Sancarn's articles on various topics related to VBA.
Large catalogue of tutorials - beginner through to advanced. Delves into interesting areas of VBA not explored by other content creators.
A great place to ask questions. Duplicate questions are flagged as duplicates and send the author to the correct place.
Write bulletproof VBA code for any situation. This book is the essential resource for developers working with any of the more than 300 products that employ the "Visual Basic for Applications" programming language. Hardbacks also available elsewhere.
A great reference to numerous data structures and mechanics.
Archived copy of vbAccelerator site (articles, source code, etc.) that disappeared in 2015, reappeared in 2018, and anyone's guess what's going to next… Primarily VB6, but useful VBA resource.
Forum with focus on VB6/.NET with VBA section.
A chat room for VB.NET/VBA/VB6 fanatics.
Great all-round resource for VBA. Perfect introduction for beginners. In-depth lessons into all aspects of VBA. Huge playlist that covers most types of VBA.