Excel VBA - Advanced VBA Macros (1-Day Webinar)

Full-Day Webinar - Hosted Using Teams

Course Objectives: This is the follow-up class to Introduction to VBA Macros. In this 1-day class, we continue using VBA to automate Excel tasks. Explore more fundamentals of Excel VBA including effective decision making, using worksheet events, debugging, and error handling.

Prerequisites: Due to the technical content, Introduction to VBA Macros is required prior to enrolling in this course. Before taking this course, you should be comfortable recording macros, finding and editing macros as well as writing basic VBA code. You should also be aware that our VBA classes are somewhat technical in nature since they involve programming

If you have any questions, feel free to contact us to discuss if this level is right for you.

Course Content :

• More Fundamentals of Excel VBA: The Visual Basic Editor, Objects and Properties
• Excel Objects: Object Hierarchy, Application, Workbook, Worksheet, and Range
• Variables and Constants: Data types, Variable Levels and Declaring Variables
• Loops: Types of Loops and Using Loops
• Effective Decision Making: If/And/Or, Select Case
• Workbook and Worksheet Events
• Debugging and Error Handling: Error Handling and Prevention
• Excel Worksheet Functions in VBA: Specific Examples
• User Forms Introduction

See full class outline here.