Excel VBA Tutorial – Learn VBA from Basics to Advanced (2026)

• Worth learning?
• Setup
• First macro
• Learning path
• 10 patterns
• 64-bit
• What next
• FAQ

Excel VBA lets you replace work you do by hand with code that does it in one click. This tutorial takes you from opening the editor for the first time to writing automation that pulls from databases, drives Outlook and builds its own user interface.

Every topic below links to a full lesson with working code you can copy, and most come with a downloadable example file. The path is ordered — if you are new, start at Stage 1 and work down. If you already write macros, use the jump links above.

Is VBA still worth learning in 2026?

A fair question, and most tutorial sites dodge it. Here is the honest answer.

VBA is no longer the only way to automate Excel. Three alternatives now exist, and each is better than VBA at something.

When VBA is still the right answer

• The file lives on a desktop, not in SharePoint or OneDrive.
• You need to drive Outlook, Word, PowerPoint or Access from Excel.
• You need a UserForm — a real dialog with buttons and inputs.
• You are maintaining an existing macro-enabled workbook. There are tens of millions of them.
• Your organisation blocks Office Scripts or the Python runtime, which many do.

When to reach for something else

VBA is not growing. It is also not going anywhere: it ships in every desktop copy of Office and Microsoft has committed to supporting it. Learning it is still one of the highest-return skills in an office job, because it is the only one of the four that works everywhere without asking IT for anything.

Before you start: three things to set up

1. Turn on the Developer tab
   File → Options → Customize Ribbon, then tick Developer in the right-hand column. You can skip this and press Alt + F11 to open the editor directly, but the Developer tab is where the Macro Recorder and the form controls live.
2. Save as .xlsm, not .xlsx
   An .xlsx file silently discards all VBA code when you save it. Use Excel Macro-Enabled Workbook (*.xlsm). This is the most common way beginners lose an afternoon’s work.
3. Understand macro blocking
   Since 2022, Excel blocks macros by default in any file that came from the internet or from email. This catches almost everyone at least once — see the box below.

Your first macro

Press Alt + F11, then Insert → Module, and paste this in.

Option Explicit

Sub HelloWorld()
    MsgBox "Hello World!", vbInformation, "My First Macro"
End Sub

Click anywhere inside the code and press F5. A message box appears.

Two things in there are deliberate and worth carrying into every macro you write. Option Explicit at the top of the module forces you to declare every variable — without it, a typo like totl instead of total creates a silent new empty variable and your code returns the wrong number with no error at all. The vbInformation and title arguments are optional, but MsgBox accepts them, and knowing what a procedure will accept is most of what learning VBA consists of.

Full lesson: writing your first VBA macro

VBA tutorial: the learning path

Four stages. Each row links to a full lesson with examples and, in most cases, a downloadable file.

• 1. Foundations
• 2. The language
• 3. Excel objects
• 4. Advanced

Stage 1 — Foundations

Get the editor open, record something, run it, and understand what you are looking at.

Stage 2 — The language

Variables, logic and loops. This is the stage where you stop recording and start writing.

Stage 3 — Working with Excel

Applying the language to the objects you actually care about.

Stage 4 — Advanced

Interfaces, events, other applications and databases.

Ten patterns you will use constantly

If you learn nothing else on this page, learn these. Every one is production-ready — declared variables, no .Select, and safe to drop into real work.

1. Find the last used row

Dim lastRow As Long
lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row

Always anchor to a specific worksheet variable. Cells(Rows.Count, 1) with no sheet reference breaks the moment a different sheet is active.

Full lesson: finding the last used row with data

2. Loop a range without selecting anything

Dim cell As Range

For Each cell In ws.Range("A2:A" & lastRow)
    If cell.Value = "" Then cell.Value = "N/A"
Next cell

3. Loop every worksheet

Dim ws As Worksheet

For Each ws In ThisWorkbook.Worksheets
    ws.Range("A1").Value = ws.Name
Next ws

4. Read a range into an array — the big speed win

Dim data As Variant

data = ws.Range("A1:D10000").Value    ' one read instead of 40,000

Touching the worksheet is slow; touching memory is not. On large ranges this is routinely 50 to 100 times faster than looping cell by cell.

5. Speed up any long-running macro

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False

    ' ... your code ...

Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True

Always restore these, including when the code errors. Pattern 10 shows how.

6. Copy without the clipboard

' Copy everything, including formats
wsSource.Range("A1:D100").Copy Destination:=wsTarget.Range("A1")

' Values only, and much faster
wsTarget.Range("A1:D100").Value = wsSource.Range("A1:D100").Value

7. Delete rows safely by looping backwards

Dim i As Long

For i = lastRow To 2 Step -1
    If ws.Cells(i, 1).Value = "DELETE" Then ws.Rows(i).Delete
Next i

A forward loop skips a row after every deletion, because everything below shifts up while the counter moves down.

8. Check whether a sheet exists

Function SheetExists(sheetName As String) As Boolean
    Dim ws As Worksheet

    On Error Resume Next
    Set ws = ThisWorkbook.Worksheets(sheetName)
    On Error GoTo 0

    SheetExists = Not ws Is Nothing
End Function

9. Fast lookups with a Dictionary

Dim dict As Object
Set dict = CreateObject("Scripting.Dictionary")

dict("APPLE") = 1.5

If dict.Exists("APPLE") Then MsgBox dict("APPLE")

Late binding with CreateObject avoids a broken reference on machines without the Microsoft Scripting Runtime library. A Dictionary lookup is near-instant; a nested loop over 10,000 rows is not.

10. Error handling that always cleans up

Sub ProcessData()
    On Error GoTo CleanFail
    Application.ScreenUpdating = False

    ' ... your code ...

CleanExit:
    Application.ScreenUpdating = True
    Exit Sub

CleanFail:
    MsgBox "Error " & Err.Number & ": " & Err.Description, vbExclamation
    Resume CleanExit
End Sub

A note on 64-bit Office

Most new installations are 64-bit. Ordinary VBA is unaffected, but Windows API declarations must be updated or the project will not compile.

' Old — 32-bit only, fails to compile on 64-bit Office
Declare Function GetTickCount Lib "kernel32" () As Long

' Correct for both
#If VBA7 Then
    Declare PtrSafe Function GetTickCount Lib "kernel32" () As Long
#Else
    Declare Function GetTickCount Lib "kernel32" () As Long
#End If

If you inherit a workbook that fails on a modern PC with “The code in this project must be updated for use on 64-bit systems”, this is almost always the reason.

Where to go next

Frequently asked questions

Related Excel VBA guides

• 100+ most useful Excel VBA codes — the full macro library.
• VBA Code Explorer — browse by object, method and property.
• Excel chart VBA examples — 33 worked chart macros.
• 15 macros for absolute beginners — with a downloadable file.
• 100+ VBA interview questions — with worked answers.
• Advanced VBA programming — class modules, events and structure.