Skip to content
64

Awesome VBA

A curated list of awesome VBA/VB6 frameworks, libraries, software and resources

651 stars73 forks18 entriesLast push Nov 11, 2026 (4 days ago)License Other

This page lists names, links and short descriptions. The original list on GitHub is the source and belongs to its authors.

Examples >UI Ribbon

Access 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.

Style Guides

VB6 Coding conventions

Variable/Class/Module naming conventions used in VBA. Greatly helps organisation in VBE (unless you have rubberduck).

Information

SAFEARRAYS

The internal structure of arrays.

Link may be dead

Resources >Win32 API Resources

Microsoft Office Code Compatibility Inspector

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…

Resources >VB6 / VBScript

Planet Source Code

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.

Resources >Websites

MSDN VBA Documentation

MS-VBAL Language Spec

Leandro Ascierto's website - Full of low-level examples of using VBA and VB6. The original site closed in September…

Link may be dead

Resources >Books

(E-Book) VBA beginners

(E-Book) Excel VBA beginners

Resources >YouTube

Excel for Freelancers

Hands-on tutorials to developing specific applications from beginning through to end. All levels.

Resources >Forums

Reddit

Daily VBA Q&A. Occasional Pro-Tip sharing and Show & Tell library publishing.

Link may be dead

Stack Overflow

A great place to ask questions. Duplicate questions are flagged as duplicates and send the author to the correct place.

Link may be dead

Visual Basic Discord

A chat room for VB.NET/VBA/VB6 fanatics.

Excel Discord

Discord server moderated by Tim Heng (Excel MVP) with focus on helping Excel users.

MrExcel

Mostly Excel generic, but a lot of VBA content can be found here also.

Link may be dead

Excel Forum

Link may be dead

VBForums - Office Development

Forum with focus on VB6/.NET with VBA section.

Link may be dead
See category
100

Awesome Python

vinta/awesome-python

The definitive list that answers "I want to do X in Python, which tool should I use?"

Fresh★ 335k562 entriesPushed today
99

Awesome Swift

matteocrippa/awesome-swift

A collaborative list of awesome Swift libraries and resources. Feel free to contribute!

Fresh★ 26k1101 entriesPushed 4 days ago
98

Awesome Mac

jaywcjlove/awesome-mac

 This project is dedicated to collecting high-quality macOS software and organizing them systematically by different categories for easy search and use.

Fresh★ 119k1607 entriesPushed today
98

Awesome PHP

ziadoz/awesome-php

A curated list of amazingly awesome PHP libraries, resources and shiny things.

Fresh★ 33k87 entriesPushed 16 days ago
98

Awesome Neovim

rockerBOO/awesome-neovim

Collections of awesome neovim plugins.

Fresh★ 22k1461 entriesPushed today
98

Awesome Go

avelino/awesome-go

A curated list of awesome Go frameworks, libraries and software

Fresh★ 194k3181 entriesPushed today