Microsoft Private

Excel Programming with VBA (EXC_VBA)

3 days
Microsoft ExcelMicrosoft OfficeMicrosoftVBA

Build practical Excel VBA skills using the Visual Basic Editor, object model, variables, control structures, custom dialogs, automation, and error handling.

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 Excel VBA course teaches you to automate tasks and manipulate Excel objects with Visual Basic for Applications. You will use the Visual Basic Editor, explore the Excel object model, create variables, apply selection and repetition structures, build custom dialogs, automate processes, and handle errors.

Each lesson introduces a VBA feature and demonstrates how to apply it in Excel. Private training can be tailored to the version of Excel used in your organization.

Course Benefits

  • Understand how the Visual Basic editor works in Excel.
  • Learn to work with the VBA object model.
  • Learn to work with VBA object variables.
  • Learn to work with string variables.
  • Learn to work with date variables.
  • Learn to work with numeric variables.
  • Learn to use the selection structure.
  • Learn to use the Select Case statement and the MsgBox function.
  • Learn to work with the repetition structure.
  • Learn to work with option button, check box, and list box controls.
  • Learn to use Automation.
  • Learn to trap errors.

Delivery Methods

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

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner. We design and deliver training that aligns directly with Microsoft's official technologies, standards, and learning objectives.

Microsoft Certified Partner

Course Outline

  1. Introducing the Visual Basic Editor
    1. Using the Visual Basic Editor
  2. Working with the Object Model
    1. Using the Object Model
  3. Working with the Object Variables
    1. Creating and Using Object Variables
  4. Working with String Variables
    1. Using String Variables
  5. Working with Date Variables
    1. Discussing Date Variables
    2. Using Date Variables
  6. Working with Numeric Variables
    1. Discussing Numeric Variables
    2. Using Numeric Variables
  7. Using the Selection Structure
    1. Discussing the Selection Structure
    2. Using the Selection Structure
  8. Using the Select Case Statement and the MsgBox Function
    1. Understanding Select Case Statement and MsgBox Function
    2. Using the Select Case Statement and the Msgbox Function
  9. Working with the Repetition Structure and the With Statement
    1. Understanding the Repetition Structure and the With Statement
    2. Using the Repetition Structure and the With Statement
  10. Advanced Repetition Structure and String Functions
    1. Using the String Repetition Structure and String Functions
  11. Working with Option Button, Check Box, and List Box Controls
    1. Discussing the Dialog Box Controls
    2. Using the Option Button, Check Box, and List Box Controls
  12. Automation
    1. Understanding the Automation Process
    2. Using Automation
  13. Advanced Automation and Error Trapping
    1. Discussing Automation and Error Trapping
    2. Using Automation and Error Trapping

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 Microsoft Excel class:

Advanced proficiency with Microsoft Excel is required.

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