Microsoft Private

Introduction to Visual Basic for Applications (VBA) - VBA101 (VBA101)

3 days
Microsoft OfficeVBAMicrosoft

Learn VBA fundamentals to automate tasks in Microsoft Excel, Word, and Access using the Visual Basic Editor, object models, variables, and selection logic.

Talk to a Learning ConsultantRequest a Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

This introductory VBA course teaches you to automate and manipulate objects in Microsoft Excel, Word, and Access. You will use the Visual Basic Editor, navigate Office object models, create object and value variables, and control program flow with selection structures.

Each topic begins with core concepts and then demonstrates how to apply them across all three applications.

Course Benefits

  • Use the Visual Basic Editor in Microsoft Excel, Word, and Access.
  • Navigate and work with VBA object models.
  • Create and use object variables.
  • Store and manipulate string, date, and numeric values.
  • Use selection structures to control program flow.
  • Apply core VBA techniques consistently across Excel, Word, and Access.

Delivery Methods

Private Class
Delivered for your team at your site or online.

Course Outline

  1. Introducing the Visual Basic Editor
    1. Using the Visual Basic Editor
    2. Using the Visual Basic Editor in Excel
    3. Using the Visual Basic Editor in Word
    4. Using the Visual Basic Editor in Access
  2. Working with the Object Model
    1. Using the Object Model
    2. Using the Object Model in Excel
    3. Using the Object Model in Word
    4. Using the Object Model in Access
  3. Working with Object Variables
    1. Using Object Variables
    2. Creating and Using Object Variables in Excel
    3. Creating and Using Object Variables in Word
    4. Creating and Using Object Variables in Access
  4. Working with String Variables
    1. Using String Variables
    2. Using String Variables in Excel
    3. Using String Variables in Word
    4. Using String Variables in Access
  5. Working with Date Variables
    1. Understanding Date Variables
    2. Using Date Variables in Excel
    3. Using Date Variables in Word
    4. Using Date Variables in Access
  6. Working with Numeric Variables
    1. Understanding Numeric Variables
    2. Using Numeric Variables in Excel
    3. Using Numeric Variables in Word
    4. Using Numeric Variables in Access
  7. Using Selection Structures
    1. Understanding Selection Structures
    2. Using Selection Structures in Excel
    3. Using Selection Structures in Word
    4. Using Selection Structures in Access

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this VBA class:

  • Advanced proficiency with Microsoft Excel, Word, and Access.

Prerequisite Courses

Courses that can help you meet these prerequisites:

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant