Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6.0 (VB6) built into most desktop Microsoft Office applications. This is a curated list of Libraries and Resources for both VBA and VB6.

Mar 18, 2020 · Hello r/vba, today I wanted to share my free and open-source VBA function library, XLib. XLib includes around 120 functions, is very small in size (around 60 KB), and is written in pure VBA, so you can easily add it to your Office file by simply copying and pasting the source code into a Module, or by importing the Xlib.bas file.

VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications. Topics microsoft macros vba vba-library microsoft-excel

Atom.io is a great IDE for any language to just easily type some code and save. I already use it for python and some easy scripting languages to check my syntax. I actually found a package for VBScript/VBA syntax highlighting: here! You can download it right in Atom:

Apr 7, 2025 · A series of Visual Basic Applications (VBA) methods I wrote, mostly for Excel, to increase the speed and accuracy in working with data, charts and databases.

Mar 20, 2025 · Which are the best open-source Vba projects? This list will help you: excelize, oletools, EvilClippy, Rubberduck, calamine, ViperMonkey, and git-xl.

6 days ago · Which are the best open-source vba-excel projects? This list will help you: VBA, QRCodeLibVBA, VBA-SQL-Library, Vincenty-Excel, VBA-ExtendedDictionary, JustMoreVBA, and Excel-Pomodoro-Timer.

May 27, 2019 · Visual Studio code and Sublime Editor have VBA extensions that give your code syntax highlighting. In the Visual Studio Code Extensions menu, search for VSCode VBA by Scott Spence and click the button to install it. This will give you proper syntax highlighting:

Jan 26, 2020 · My main project is an Excel function library, named XPlus, which contains over 100 functions in it. A few of the functions include: XPlus is written in pure VBA so its easy to embed in a spreadsheet and is only around 60KB in size, making it a very small addition to the spreadsheet.

Mar 18, 2020 · Hello r/excel, today I wanted to share my free and open-source VBA function library, XLib. A couple months ago I released XPlus, a function library for Excel. Since the library is written is in VBA, it was easy to use those same functions in VBA code for other purposes.