Excel VBA Programming Day 1: Write, Edit and Debug VBA Code in Excel Macros
Learn to create automated custom Excel applications using VBA. This is the first day of our two-day VBA Programming course, which helps advanced Excel users develop new skills to write and debug powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors.
Course Outline
VBA Concepts
- The Object Model Hierarchy
- Understanding Properties, Methods and Events
Accessing VBA Functionality
- 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 Quick Access Toolbar
- To the Ribbon
- To Buttons
Using Variables
- VBA Data Types
- Declaring Variables
- Scope of Variables
Note: This class is ideally suited for experienced Excel users who want to learn how to write programming code using Visual Basic for Applications.