VBA editor basics in Excel - Step-by-Step Guide

Introduction

The VBA editor lets you write and edit small programs inside Excel to automate tasks. It helps you save time by running repetitive actions with a click.

When you want to automate formatting for many sheets quickly

When you need to create a custom button that runs a set of commands

When you want to repeat a task like copying data without doing it manually

When you want to create a simple form to enter data faster

When you want to add logic that Excel formulas alone cannot handle

Steps

Step 1: Click

- Developer tab on the Excel ribbon

The Developer tab options appear, including Visual Basic

💡 If Developer tab is not visible, enable it in Excel Options under Customize Ribbon

Step 2: Click

- Visual Basic button on the Developer tab

The VBA editor window opens showing your workbook's project

💡 You can also press Alt + F11 to open the VBA editor quickly

Step 3: In the Project Explorer pane, right-click

- VBAProject (your workbook name)

A menu appears with options like Insert and Remove

💡 If Project Explorer is not visible, click View > Project Explorer

Step 4: Select

- Insert > Module

A new blank module opens where you can type VBA code

💡 Modules hold your VBA code separate from sheets or workbook events

Step 5: Type

- Code window of the new module

You see your VBA code ready to run or edit

💡 Start with simple code like Sub Hello() MsgBox "Hi" End Sub

Step 6: Click

- Run button (green triangle) or press F5

Your VBA code runs and shows any output or message boxes

💡 Use this to test your code quickly

Step 7: Close

- VBA editor window

You return to Excel with your VBA code saved in the workbook

Before vs After

Before

Excel workbook with no VBA code and no Developer tab visible

After

VBA editor opened with a new module ready for code and Developer tab visible on the ribbon

Settings Reference

Trust access to the VBA project object model

📍 File > Options > Trust Center > Trust Center Settings > Macro Settings

Allows VBA code to interact with the VBA editor and projects

Default: Disabled

Show Developer tab

📍 File > Options > Customize Ribbon

Makes the Developer tab visible on the Excel ribbon

Default: Unchecked

Auto Syntax Check

📍 VBA editor > Tools > Options > Editor tab

Shows error messages immediately when typing incorrect code

Default: Enabled

Common Mistakes

Trying to run VBA code without opening the VBA editor

You cannot write or edit VBA code directly in Excel cells

Open the VBA editor via Developer tab or Alt + F11 to write and run code

Not enabling the Developer tab and looking for VBA options

VBA tools are hidden if Developer tab is not enabled

Enable Developer tab in Excel Options under Customize Ribbon first

Typing code in the wrong place like worksheet cells

VBA code must be typed inside modules or objects in the VBA editor

Insert a module in the VBA editor and type code there

Summary

The VBA editor is where you write and run small programs inside Excel.

Open it from the Developer tab or by pressing Alt + F11.

Insert modules to organize your code and use the Run button to test it.