Microsoft Excel VBA

What Will I Learn?

•  Understand the VBA environment

•  Debug code using VB editor

•  Objects and Collections

•  Message boxes, input boxes, forms

•  Code execution and fix errors

•  Free digital course assets

•  Free post-course helpdesk support

Getting Started

• Displaying the Developer Tab

• Recording and running a Macro

• Macro-Enabled Workbooks

• Using the Visual Basic Editor

• The Development Environment

• Understanding Macro Security

Working with Procedures and Functions

• Understanding Modules

• Understanding Procedures

• Calling Procedures

• Creating a Function Procedure

• Working with the Code Editor

Understanding Objects

• Objects and Collections

• Working with Properties

• Using the With Statement

• Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions

• Understanding Expressions and Statements

• Declaring Variables

• Understanding Data Types

• Using Intrinsic Functions

• Understanding Constants

• Declaring and using Object Variables

Controlling Program Execution

• Control-of-Flow Structures

• Working with Boolean Expressions

• Different types of Control-of-Flow structures

• Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls

• Working with UserForm Properties, Events and Methods

• Working with different Controls

• SettingControl Appearance

• Populating a Control

• Adding Code to Controls

• Launching a Form in Code

Handling Errors

• Understanding Error Handling

• Writing an Error-Handling Routine

• Working with Inline Error Handling