Excel VBA Macros: Write Custom Excel Macros in VBA

Learn to create automated custom Excel applications using VBA. This two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors.

Prerequisites:

This class is ideally suited for experienced Excel users who want to learn how to write programming code using Visual Basic for Applications.

Outline:

VBA Concepts

• The Object Model Hierarchy
• Understanding Properties, Methods and Events

Getting Started with VBA

• Macro Security Options
• Using the Macro Recorder

Editing Macros

• Essential VB Editor Components
• VB Toolbars
• Using the Object Browser
• VBA Module and Procedure Types
• Writing Solid Code

Debugging Macros

• Types of Programming Errors
• VBE Debugging Tools
• Stepping Through Code
• Break Mode and Breakpoints
• Watch Expressions
• The Immediate window and Locals window

Assigning Macros

• To the Toolbar
• To the Ribbon
• To Buttons

Using Variables

• VBA Data Types
• Declaring Variables
• Scope of Variables