Excel VBA

What We'll Explore:

1. Understanding How Excel, VBA, and the Coding Editor Fit Together
2. Getting Around the Visual Basic Coding Editor
3. Accessing and Manipulating Excel Objects
4. Using Variables, Control Structures, Loops and Subroutines
5. Getting User Input and Creating Custom Dialog Boxes
6. Debugging and Error Handling

Day 1 Topics:

Introduction to VBA Usage and Terminology

• Defining VBA and What It Can Do
• Comparing Macros vs. Programming
• Exploring the Visual Basic Editor Tool
• Activating and Using the Developer Tab

Programming Basics

• Understanding VBA Syntax and Help Resources
• Creating VBA Sub Procedures
• Getting Information with Input Boxes
• Delivering Information with Message Boxes
• Using Variables for Flexibility
• Understanding Scope of Variables and Procedures
• Defining and Using Functions and Sub Procedures

Creating Decision Structures

• Understanding How a Decision Structure Interprets Conditions
• Using IF…Then Statements
• Creating IF… Then… ElseIF Statements
• Applying Select Case Statements

Day 2 Topics:

Creating Looping Structures

• Using Loops to Repeat Processes
• Implementing a Fixed Iteration Loop
• 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 the Workbook
• Processing Collected Data with VBA

Debugging and Error Handling

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