VBA

Arrays in VBA

Store and process many values under one name with fixed and dynamic arrays, ReDim, and fast range-to-array techniques.

Automating Outlook and Word from VBA

Driving Outlook and Word from Excel VBA through Automation: creating application objects, composing and sending emails, and generating Word documents from temp…

Conditionals in VBA

Learn how VBA evaluates Boolean expressions to branch code using If...Then...Else, ElseIf chains, and Select Case.

Debugging VBA Macros

Learn to find and fix bugs in VBA using breakpoints, stepping, the Immediate and Locals windows, watches, and Debug.Print so you can inspect exactly what your…

Dictionaries and Collections in VBA

Comparing VBA's built-in Collection with the Scripting.Dictionary for storing keyed data, and choosing the right one for lookups, de-duplication, and counting.

Events in Excel VBA

Understand Excel's event-driven model — workbook, worksheet, and application events — and how to write handlers that respond automatically to user actions like…

Loops in VBA

Master repetition in VBA with counter-driven For...Next, collection-driven For Each, and condition-driven Do loops.

Performance Tips for VBA

Make VBA macros dramatically faster by minimising interaction with the Excel object model, disabling screen and calculation overhead, and moving data through a…

Ranges and Cells in VBA

Master the Range object — the workhorse of Excel VBA — including how to reference cells, read and write values efficiently, and navigate with properties like C…

Regular Expressions in VBA

Using the VBScript RegExp object to match, extract, and replace text patterns in VBA, including groups, global matching, and common gotchas.

Securing and Protecting VBA Code

Understand how to protect VBA projects and workbook contents, the real limits of VBA password protection, macro security settings, and digital signing to keep…

Subs and Functions in VBA

Understand VBA's two procedure types—action-performing Subs and value-returning Functions—plus arguments, scope, and UDFs.

The VBA Editor and Macro Recorder

A tour of the Visual Basic Editor and the Macro Recorder: the two tools every VBA beginner uses to write, explore, and learn code.

VBA and ADO Database Access

Using ActiveX Data Objects (ADO) from VBA to connect to databases, run parameterized queries, and read results into a worksheet or recordset.

VBA and Python Alternatives

Compare VBA with modern alternatives — Python (openpyxl, pandas, xlwings), Office Scripts, and Power Query — to choose the right automation tool and understand…

VBA Best Practices

Practical conventions for writing maintainable, fast, and robust VBA — from Option Explicit and naming to error handling, performance, and avoiding Select/Acti…

VBA Data Types and Scope

How VBA stores values and controls their visibility: the core data types, variable scope and lifetime, constants, and object variables.

VBA Interview Questions

The concepts VBA interviews probe most — variables and scope, error handling, workbook/worksheet references, performance, and events — with model answers.

VBA Quick Reference

A compact cheat-sheet of the VBA constructs you reach for daily — variable types, loops, range navigation, common objects, and handy snippets.

VBA Syntax and Variables

The building blocks of every macro: procedures, variable declaration with Dim, operators, and comments in VBA's readable, line-based syntax.

VBA vs Office Scripts

A practical comparison of classic VBA macros against Microsoft's newer TypeScript-based Office Scripts, covering runtime, platform reach, security, and when to…

What Is VBA?

An introduction to Visual Basic for Applications: what it is, where it runs, and why it remains the workhorse of desktop Office automation.

Working with Charts in VBA

Create, configure, and format Excel charts programmatically using the ChartObject and Chart objects, set source data and chart types, and understand embedded c…

Your First VBA Macro

Write, run, and debug your very first macro: set up the Developer tab, add a module, greet the user with MsgBox, write to a cell, and step through the code.