20.1 Introduction
Learning Objectives
-
Identify the different types of errors that can occur in VBA and understand how to handle them.
-
Debug VBA programs, including using debug points, the Immediate window, and the Locals window to identify and correct errors.
-
Add descriptions to UDFs and categorize them.
-
Protect VBA code with a password.
-
Save VBA code as an Excel add-in.
This lesson provides additional coverage of VBA-related topics, including debugging, error handling, adding descriptions, and categorizing user-defined functions, or UDFs.
Lesson Files
VBA 3 - Declaring and Describing Functions - Class File