VBA

Walk-through and source code for an Excel VBA development workflow

What is Microsoft's take on Office Scripts vs VBA in 2022. Will Office Scripts replace Visual Basic for Applications Macros?

This quick tutorial will have you writing custom events in VBA in no time.

Move over Rubberduck VBA and MZ-Tools. The next great VBE addin is going to be built with twinBASIC. Here are step-by-step instructions to get you started.

Tool that draws VBA structure of your MS Excel file.

This simple VBA function will check the user's registry and return the latest ODBC driver from a list of supported drivers that you can customize.

This simple VBA function will check the user's registry and return the latest OLE DB provider from a list of supported providers that you can customize.

Interfacing VBA and .NET is a relatively straightforward process.

Learn all about Excel VBA errors and how make sure these are handled properly in your VBA code. Covers all the error types and error handling methods.

VBA Code Excel Object Explorer : Example Macros on Workbook, Worksheet, Range, Cells, Charts, Pivot tables, Shapes, List Objects (Tables) Methods, Properties, Events.

Do you use MS Office day-to-day? Have you heard of VBA? If not, then you might want to see what, exactly, Visual Basic is all about.

Tired of your Excel macro grinding to a halt or not knowing who has the latest spreadsheet file? Learn by converting excel VBA macros to web application.

MZ-Tools has a single goal: To make your everyday programming life easier. As an add-in to several Integrated Development Environment (IDEs) from Microsoft, MZ-Tools adds new menus and toolbars to them that provide many new productivity features.

VBA code examples. Addins for excel and powerpoint

AJP Excel information

The best online resource for all your Excel & VBA requirements

xlDynamic.com Home Page

Create a Table of Contents This code creates/updates a Table of Contents for a specific workbook.

This is a Microsoft Office Visual Basic for Applications Discussion Forum and Code Center

Excel VBA || Learn what is VBA and lots more. Also get access to the excel VBA programming Code for how to create a message box, input box, etc. Read on.

Glossary of terms for Visual Basic for Applications (VBA).

Glossary of terms for Visual Basic Editor (VBE).

Ever wanted to determine which OBDC drivers are installed on a PC, maybe SQL Server specific OBDC drivers? Find out how easy it can be done via VBA.

ALWAYS Use Option Explicit, Work with Arrays, Not With Ranges, Switch off properties during macro execution, Use VB constants when available, Avoid using SELECT or ACTIVATE, Always define and set references to all Workbooks and Sheets, Use descriptive variable naming, Document Your Work, Error Handling, Never Assume The Worksheet, Avoid using ActiveCell or ActiveSheet in Excel, WorksheetFunction object executes faster than a UDF equivalent, Avoid re-purposing the names of Properties or Methods as your variables

Posts about clean-code written by Rubberduck VBA