Summary  
This chapter explains the concept of code modules as the primary container for VBA procedures and shows how to insert and organize modules within a VBA project hierarchy.

General domain of usage  
Spreadsheet automation

VBA's tools are hidden by default because most Excel users never need them. Before you write a line of code, you need to switch on the **Developer** tab, get comfortable with the **Visual Basic Editor (VBE)**, and understand the one file-format rule that trips up almost every beginner.

#### Enabling the Developer Tab
1. Go to **File → Options**;
2. Click **Customize Ribbon**;
3. In the right-hand list of main tabs, check the box next to **Developer**;
4. Click **OK**. The Developer tab now appears in your ribbon.


Excel Workbook

### Opening the Visual Basic Editor
Press `Alt+F11` from anywhere in Excel (or click Visual Basic on the Developer tab). This opens the VBE — a separate application window where all VBA code lives. Three panels matter most while you're learning:
- **Project Explorer** (top-left) — a tree view of every open workbook, its worksheets, and its code modules;
- **Properties window** (bottom-left) — settings for whatever object is selected in the Project Explorer;
- **Code window** (right) — where you read, write, and run VBA procedures.


#### Exploring the Project Explorer

In the image above, notice the hierarchy: 
VBAProject (Section_1_VBA_Intro.xlsm) contains Microsoft Excel Objects (one entry per worksheet, plus ThisWorkbook) and, once you add any code, a Modules folder. Standard code — the kind you'll write for most of this course — belongs in a Module, not directly behind a worksheet or ThisWorkbook. **Right-click VBAProject → Insert → Module to add one**.


#### Saving Macro-Enabled Workbooks (.xlsm)

If you save a workbook that contains VBA code as a normal Excel Workbook (`.xlsx`), Excel silently deletes every macro. There is no warning dialog you can miss — Excel does warn you, but it's easy to click through without reading it. Always choose **Excel Macro-Enabled Workbook** (`*.xlsm`) from the "Save as type" dropdown whenever a file contains code.

Note

## Task
Get your environment ready.
1. Open **Section_1_VBA_Intro.xlsx** and enable the **Developer** tab if it isn't already visible.
2. Press `Alt+F11` and locate the **Employees** worksheet and **ThisWorkbook** in the Project Explorer.
3. Insert a new Module (right-click the **VBAProject → Insert → Module**) and rename it in the Properties window to `modIntro`.
4. Save the file as **Section_1_VBA_Intro.xlsm** using **File → Save As → Excel Macro-Enabled Workbook**.


Discover how to transform Excel from a static spreadsheet tool into a powerful engine for business automation. This course takes you from writing your very first macro to building a complete, multi-step workflow that imports data, generates reports, and sends emails — all with a single click. Master the core VBA skills that let you eliminate repetitive manual work: reading and writing data at scale, building interactive forms, automating tables and PivotTables, and handling errors like a professional developer. Along the way, you'll get hands-on experience with realistic business scenarios — invoicing, batch file processing, and reporting — using sample datasets built specifically for practice. By the end, you'll have the confidence and technical foundation to design your own automation solutions, saving hours of manual effort in real spreadsheets you use every day.

Dive into the fundamentals of VBA by exploring the Excel object model and setting up your development environment. Learn to record, run, and write your first macros, and gain a solid understanding of how Application, Workbook, Worksheet, and Range objects fit together.

Build confidence in core programming concepts: variables, data types, operators, and built-in functions. Master conditional logic and loops, and apply them to a real dataset by creating a working stock alert macro.

Learn the secrets of reading, writing, and formatting cell data efficiently. Explore techniques for navigating worksheets, working with dynamic ranges, and processing large datasets using arrays for maximum performance.

Get hands-on experience automating Excel Tables, filters, PivotTables, and charts. Discover how to build fully automated, refreshable business reports directly from VBA.

Explore how to make your macros interactive using message boxes, input boxes, and custom UserForms. Learn to validate user input and build user-friendly data entry tools.

Setting Up the VBA Environment

Enabling the Developer Tab

Opening the Visual Basic Editor

Exploring the Project Explorer

Saving Macro-Enabled Workbooks (.xlsm)

Task