/awesome-vba

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

OtherNOASSERTION

awesome-vba

A note on symbology

To help you in finding projects suitable for you, this awesome list uses the following symbology. The symbology also has tooltips which may provide more information.

Platform Compatibility

Application compatibility

Other important information

Contents


Frameworks

Libraries

Data Formats

JSON

CSV

XML

Data Structures

Array-List

Dictionary

Math libraries

Database tools

Userform tools

Low level tools

Parsers / Interpreters

Web tools

Developer tools

Examples

UI Ribbon

  • Ron de Bruin - Ribbons/QAT - A leading resource for information/samples on developing custom ribbons and context menus.
  • Office MSO Icons - Ribbon icons can often use one of the 1500 (3 pages on this site) MSO icons wich pre-exist in Office applications.

UI Userforms

Low level examples

VBE UI

AddIns

  • ๐Ÿ–ผ๐Ÿ“Š MenuRighter - MenuRighter is an Excel addin that lets you modify right-click menus. You can add almost any control found in other right-click menus or Excel 2003โ€™s โ€œclassicโ€ menus.
  • ๐Ÿ–ผ๐Ÿ“Š Sam Rad's DatePicker - Visually impressive and professional DatePicker addin for Excel. Worksheet only / cannot be used with userforms.

Games / Fun projects

External tools

Style Guides

Information

  • Thunder - The birth of Visual Basic - A little article about the birth of VB7/VBA
  • 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. IDispatch, Variant, For each and With. It also discusses the dreaded Date bug ported to Excel from Lotus 123.
  • Ruby, EB and DLL composition - 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.
  • PCode Internals - VBA is compiled to PCode. Understanding the lower level P-Code is a topic of heavy interest and research.
  • How many lines of code in EB - Untranlated article by Russian VBer ะฅะฐะบะตั€ which estimates the number of lines of code in VB6/VBA.
  • SAFEARRAYS - The internal structure of arrays.

Resources

Websites

Books

  • 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 solutions to problems to achieve a wide range of functional programs. A hard book also exists. Also check out the Comments and corrections.
  • 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 more than 300 products that employ the "Visual Basic for Applications" programming language. Hardbacks also available elsewhere.
  • Advanced Visual Basic 6 - Power Techniques for Everyday Programs Matthew Curland. Hardbacks also available elsewhere.
  • 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. Hardbacks also available.
  • ๐Ÿ’ฒ 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 stepโ€“byโ€“step instruction and the accessible, friendly For Dummies style, this practical book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more
  • ๐Ÿ’ฒ Power Programming with VBA - Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications.
  • (E-Book) VBA beginners
  • (E-Book) Excel VBA beginners

Youtube

  • Excel Macro Mastery - Youtube channel for Paul Kelly (MVP) - excelmacromastery.com.
  • Sigma Coding - Large catalogue of tutorials - beginner through to advanced. Delves into interesting areas of VBA and it uses not explored by other content creators.
  • 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 most types of VBA.
  • ๐Ÿ’ฒ VBA A2Z - Many tutorials, some paid content. Good array of intereting and different topics - in-depth tutorials into different parts of VBA, with some .NET/VSTO videos. Strong focus on UI development.
  • Excel VBA Is Fun
  • Excel for Freelancers - Hands-on tutorials to developing specific applications from beginning through to end. All levels.
  • Leila Gharani - Office-wide focus - useful for beginners.
  • ๐Ÿ’ฒGet to know VBA - Some great applications presented and created with VBA.

Forums

  • Reddit - Daily VBA Q&A. Occasional Pro-Tip sharing and Show & Tell library publishing.
  • StackOverflow - A great place to ask questions. Duplicate questions are flagged as duplicates and send the author to the correct place.
  • Chandoo - Forum for the Chandoo - the blog of Purna Duggirala (MVP). Very active.
  • Visual Basic Discord - A chat room for VB.NET/VBA/VB6 fanatics.
  • Excel Discord - Focus on helping Excel users.
  • MrExcel - Mostly Excel generic, but a lot of VBA content can be found here also.
  • Excel Forum
  • ๐Ÿ“ง Slipstick - Excellent forum for the Slipstick website (Outlook VBA) of Diane Poremsky (MVP). Diane is quick to respond, and her answers are extremely helpful.
  • VBForums - Office Development - Forum with focus on VB6/.NET with VBA section.

Contributing

Your contributions are always welcome! Please take a look at the contribution guidelines first.