Microsoft Private

Excel Programming with VBA (EXC_VBA)

3 days
Microsoft ExcelMicrosoft OfficeMicrosoftVBA

Learn to automate Excel tasks with VBA, work with the Excel object model, create user interfaces, control program flow, and handle errors effectively.

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

Learn how to automate tasks and work with Excel objects using Visual Basic for Applications (VBA). This introductory course covers the Visual Basic Editor, the Excel object model, variables, program flow, loops, dialog controls, automation, and error handling.

Private training can be tailored to the version of Excel used by your organization.

Course Benefits

  • Navigate and use the Visual Basic Editor effectively.
  • Work with the Excel object model and object variables.
  • Declare and use string, date, and numeric variables.
  • Control program flow with selection structures and Select Case statements.
  • Communicate with users through the MsgBox function.
  • Write repetition structures and simplify object references with With statements.
  • Manipulate text with VBA string functions.
  • Build user interfaces with option buttons, check boxes, and list boxes.
  • Automate Excel processes using VBA.
  • Trap and handle errors in VBA programs.

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. Introduction to the Visual Basic Editor
    1. Using the Visual Basic Editor
  2. The Excel Object Model
    1. Using the Object Model
  3. Object Variables
    1. Creating and Using Object Variables
  4. String Variables
    1. Using String Variables
  5. Date Variables
    1. Understanding Date Variables
    2. Using Date Variables
  6. Numeric Variables
    1. Understanding Numeric Variables
    2. Using Numeric Variables
  7. Selection Structures
    1. Understanding Selection Structures
    2. Using Selection Structures
  8. Select Case and MsgBox
    1. Understanding Select Case and MsgBox
    2. Using Select Case and MsgBox
  9. Repetition Structures and With Statements
    1. Understanding Repetition Structures and With Statements
    2. Using Repetition Structures and With Statements
  10. Advanced Repetition Structures and String Functions
    1. Using Repetition Structures and String Functions
  11. Option Buttons, Check Boxes, and List Boxes
    1. Understanding Dialog Box Controls
    2. Using Option Buttons, Check Boxes, and List Boxes
  12. Automation
    1. Understanding the Automation Process
    2. Using Automation
  13. Advanced Automation and Error Trapping
    1. Understanding 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 VBA 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