Excel VBA

Who should attend

This live online Excel VBA course is for anyone who uses Excel.

Team Pass by Learnit

Excel VBA

From $0
Two, 2-hour Modules (9am - 11:30am PT)

In this 2-day, interactive Excel VBA course, participants will learn how to apply the VBA programming language to automate repetitive processes and make Excel spreadsheets much more powerful.

Learning Outcomes:

  • Visual Basic Editor 
  • Programming Basics 
  • Control Structures 
  • Custom Dialog Boxes
  • Debugging and Error Handling 
Course ID
L0026
Available times
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Course Outline

Day 1

Introduction to VBA Usage and Terminology

  • What is VBA and What Can VBA Do?
  • Compare Macros vs. Programming
  • Exploring the Visual Basic Editor Tool
  • Activate and use the Developer Tab

Programming Basics

  • Examining VBA Language Structure
  • Creating VBA Sub Procedures
  • Get Information with Input Boxes
  • Delivering information with Message Boxes
  • Using Variables for Flexibility
  • Scope of Variables and Procedures
  • Use of Function Procedures

Creating Decision Structures

  • How Decision Structure Interpret Conditions
  • Using IF…Then Statements
  • Creating IF… Then… ElseIF Statements
  • Apply Select Case Statements

Day 2

Creating Looping Structures

  • Using Loops to Repeat Processes
  • Applying a Fixed-Number Loops
  • Creating Infinite Loops
  • Using Loops with Workbook Objects

Designing Custom Dialog Boxes

  • Creating User Forms to Collect Data
  • Using the Form Object Designer Tool
  • Connecting Forms to Events in Workbook
  • Processing Collected Data with VBA

Debugging and Error Handling

  • Examining Programming Errors
  • Using VBA Debugging Tools
  • Applying Error Handling with VBA Code

Skills covered

No items found.