# Excel Programming with VBA

Canonical URL: <https://www.creativelive.com/classes/excel-programming-with-vba>

## Overview

VBA (Visual Basic for Applications) is the programming language used in Microsoft Excel, and it allows you to automate repetitive tasks and build powerful custom tools.

In this hands-on class, you will learn the fundamentals of VBA programming by working on real-world applications of macros and Excel automation. You will learn to automate repetitive operations, create custom commands, develop new worksheet functions, and more.

## What you'll learn

- Security
- Recording macros
- Reading and analyzing code
- Programming basic macros
- Creating complex macros
- Variables
- Looping statements
- Logic statements
- User forms
- Error trapping
- Troubleshooting

## Prerequisites

Prior VBA programming knowledge is not required, but knowledge equivalent to our [Intermediate Excel](/classes/intermediate-excel-classes) course is recommended, including VLOOKUP, Pivot Tables, and IF statements.

## Curriculum
1. **Excel VBA and Macros Level I**
2. **Excel VBA and Macros Level II**

## Schedule
- Jul 30, 2026 – Jul 31, 2026 — Live Online
- Sep 16, 2026 – Sep 17, 2026 — Live Online
- Nov 5, 2026 – Nov 6, 2026 — Live Online

## Pricing

**Tuition:** $549