Microsoft Private

Advanced Visual Basic for Applications (VBA) (VBA201)

2 days
Microsoft OfficeVBAMicrosoft

Advance your VBA skills with flow control, custom dialog boxes, Office automation, and error handling in Excel, Word, and Access in this advanced course.

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

Build advanced Visual Basic for Applications (VBA) skills for Excel, Word, and Access. This course covers flow control, repetition structures, built-in and custom dialog boxes, controls, Office automation, and error handling. Each topic begins with a general overview before demonstrating its use in each application.

Course Benefits

  • Use Select Case statements and the MsgBox function.
  • Apply repetition structures and the With statement.
  • Work with string functions and advanced repetition structures.
  • Use built-in dialog boxes and create custom dialog boxes.
  • Work with option button, check box, and list box controls.
  • Automate processes in Excel, Word, and Access.
  • Trap and handle VBA errors.

Delivery Methods

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

Course Outline

  1. Using the Select Case Statement and the MsgBox Function
    1. Understanding the Select Case Statement and MsgBox Function
    2. Using the Select Case Statement and MsgBox Function in Excel
    3. Using the Select Case Statement and MsgBox Function in Word
    4. Using the Select Case Statement and MsgBox Function in Access
  2. Working with Repetition Structures and the With Statement
    1. Understanding Repetition Structures and the With Statement
    2. Using Repetition Structures and the With Statement in Excel
    3. Using Repetition Structures and the With Statement in Word
    4. Using Repetition Structures and the With Statement in Access
  3. Advanced Repetition Structures and String Functions
    1. Using Advanced Repetition Structures and String Functions
    2. Using Advanced Repetition Structures and String Functions in Excel
    3. Using Advanced Repetition Structures and String Functions in Word
    4. Using Advanced Repetition Structures and String Functions in Access
  4. Working with Custom Dialog Boxes
    1. Creating Custom Dialog Boxes
    2. Using Custom Dialog Boxes in Excel
    3. Using Custom Dialog Boxes in Word
    4. Using Custom Dialog Boxes in Access
  5. Working with Option Button, Check Box, and List Box Controls
    1. Understanding Dialog Box Controls
    2. Using Option Button, Check Box, and List Box Controls in Excel
    3. Using Option Button, Check Box, and List Box Controls in Word
    4. Using Option Button, Check Box, and List Box Controls in Access
  6. Automation
    1. Understanding the Automation Process
    2. Using Automation in Excel
    3. Using Automation in Word
    4. Using Automation in Access
  7. Advanced Automation and Error Trapping
    1. Understanding Automation and Error Trapping
    2. Using Automation and Error Trapping in Excel
    3. Using Automation and Error Trapping in Word
    4. Using Automation and Error Trapping 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 Word, Excel, and Access.
  • Basic VBA skills equivalent to those covered in an introductory VBA course.

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