# Excel VBA and Macros Level II

Canonical URL: <https://www.careercenters.com/courses/excel-vba-and-macros-level-ii>

## Overview

### Advanced VBA Programming Classes in New York City

Dive into advanced VBA and Excel functions in Excel VBA and Macros Level II. This course builds upon lessons learned in Excel VBA and Macros Level I, including creating objects, loops, and logic statements. Learn how to control variables and create automated processes.

### Master Advanced Excel Functions with VBA

In Excel VBA and Macros Level II, you will create a user interface to input data. In addition, learn how to evaluate data with looping structures and logic statements. As with Level I,  Excel VBA and Macros Level II ends with a lesson on Error Handling, in which you'll review error numbers and descriptions.

### Enroll in VBA Bootcamp and Save

Are you an experienced Excel user who is new to VBA? Save 20% off when you enroll in the [Excel VBA and Macros Bootcamp](/courses/vba). The bootcamp includes Excel VBA and Macros Levels I and II. This two-day, 14-hour course covers Level I on the first day of bootcamp, and Level II on the second day.

### Free Retake

Retake the Excel VBA and Macros Level II course within 12 months for free.

## What you'll learn

- Navigate a workbook using offsets, range names, and variables
- Analyze data using looping structures, in combination with if and case statements
- Create user interface structures to capture multiple variable inputs
- Control the lifetime and scope of variables
- Create automated event processes
- Create automation to handle unforeseen errors and events

## Prerequisites

Students should be comfortable with the concepts covered in [Excel VBA and Macros Level I](/courses/excel-vba-and-macros-level-i).

## Curriculum

#### Lesson 1: VBA Editor

- Project Explorer
- Properties Window
- Modules

#### Lesson 2: Creating / Editing Code

- Functions
- Events

#### Lesson 3: Invoking Macros

- Worksheet Buttons
- Customize Ribbon

#### Lesson 4: Compiling Code

- Stepping through code
- Setting Breakpoints

#### Lesson 5: Variables

- Declarations
- Option Compare Text
- Option Compare Binary
- Lifetime and Scope

#### Lesson 6: Working with The Object Model

- Application
- Workbook

#### Lesson 7: Creating & Naming Objects

- Naming conventions
- Housekeeping

#### Lesson 8: Navigation / Selection Techniques

- Absolute versus Relative Reference
- Offsets

#### Lesson 9: Logic Statements

- Nested IF Statements
- Case Statements

#### Lesson 10: Functions

- Intrinsic Functions
- User Defined Functions

#### Lesson 11: Looping Statements

- For Each Next Loops

#### Lesson 12: Interactive Code

- User Forms - dashboards
- Message Boxes

#### Lesson 13: Error Handlers

- Error numbers
- Error descriptions

## Schedule
- Jun 24, 2026 10:00am–5:00pm — NYC
- Jul 31, 2026 10:00am–5:00pm — NYC
- Sep 17, 2026 10:00am–5:00pm — NYC
- Nov 6, 2026 10:00am–5:00pm — NYC

## Pricing

**Tuition:** $345