awesome-vba
github.com/sancarn/awesome-vba ↗A curated list of awesome VBA/VB6 frameworks, libraries, software and resources
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me ui ribbon resources from awesome-vba"
Installation instructions →What's inside
Examples
- Access RibbonUI Ribbon
An excellent resource for information for developing custom ribbon XML. Although principally targeted at Access, it is equally applicable to Excel, Word and PowerPoint.
- Office MSO IconsUI Ribbon
Ribbon icons can often use one of the 1500 (3 pages on this site) MSO icons wich pre-exist in Office applications.
- Ron de Bruin - Ribbons/QATUI Ribbon
A leading resource for information/samples on developing custom ribbons and context menus. (Hosted on Jan Karel Pieterse's site)
- VBSpeedAlgorithms, code optimisation, and performance testing
The Visual Basic Performance Site - focus on VB6 but transferrable across to VBA.
Resources
- Advanced Visual Basic 6Books
Power Techniques for Everyday Programs Matthew Curland. Hardbacks also available elsewhere.
- Bytecomb VBA ReferenceWebsites
Intermediate-advanced topics.
- ChandooForums
Forum for the Chandoo - the blog of Purna Duggirala (MVP). Very active.
- Chip Pearson's websiteWebsites
Great resource for beginners-intermediate.
- (E-Book) Excel VBA beginnersBooks
- (E-Book) VBA beginnersBooks
Information
- Articles by Sancarn
Various articles written by Sancarn about VBA including, performance, actual issues with VBA etc.
- How many lines of code in EB
Untranlated article by Russian VBer
- 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.
- PCode Internals
VBA is compiled to PCode. Understanding the lower level P-Code is a topic of heavy interest and research.
- Ruby, EB and DLL composition
Translated copy of
- SAFEARRAYS
The internal structure of arrays.
Style Guides
- RubberDuck's style guide
Has some great intermediate - advanced guidance.
- VB6 Coding conventions
Variable/Class/Module naming conventions used in VBA. Greatly helps organisation in VBE (unless you have rubberduck).
Showing a sample of 47 resources. View the full list on GitHub →