Microsoft Excel Level III – VBA Programming
(2-day Course)

(versions: 2003, 2007, 2010, 2016 and 2019)*

Location: Online Format (Zoom, WebEx, Google Meet)

General Overview:

This 2-day Excel Visual Basic for Applications (VBA) programming course is designed to give experienced Microsoft Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, debugging and handling errors in code.

Visual Basic for Applications (VBA) is a specific Microsoft language that integrates into any Microsoft productivity tool. This course focuses on Excel customizations and applications. To create these customizations, you first need to learn macros and what they can do for your projects.  Visual Basic is an object-oriented language, so users will be taught how to create custom classes that plug into your Excel modules.

Learning Objectives:

• Macros Development
• Format Worksheets
• Developing User Forms
• Write Code
• Debug Code
• Code Security
• Looping
• Control and Decision Structures
• The VBA Environment
• Error Handling

Target Student:

In order to be successful with this course, users should already have a thorough knowledge of Excel.

Course Outline:

Section 1: Building Solutions

• Course Overview
• Solution Concepts
• Data Entry Concepts
• Macro Concepts

Section 2: Macro Basics

• Planning Macros
• Recording Macros
• Executing Macros
• Maintaining Macros

Section 3: VBA Programming Basics

• Understanding Objects
• Using the Visual Basic Editor
• Understanding VBA Code
• Executing VBA Code
• VBA Help Reference

Section 4: User Form Basics

• Planning User Forms
• Designing User Forms

Section 5: Deployment Basics

• Preparing for Deployment
• Code Security
• Adding Macros to the Quick Access Toolbar
• Modifying Quick Access Toolbar Buttons

Section 6: Customizing Macros

• Prompting for User Input
• Automating Data Entry
• Recording Absolute vs Relative References
• Protecting VBA Code

Section 7: Enhancing VBA Code

• Writing Source Code
• Variables and Constants
• Writing Tips
• Logical Operators
• Flow Control

Section 8: Handling Errors

• Handling Errors
• Syntax Errors
• Logical Errors
• Run-Time Errors

Section 9: Accessing External Data

• External References
• ActiveX Data Object Concepts
• Connecting to a Database
• Retrieving Records from a Database

Section 10: Excel Automation

• Automation Concepts
• Working with Object Models
• Excel’s Object Model
• Automating Excel with VB Script

*All Classes are instructor led.
Class recording will be made available after the class.