This course aims to teach learners how to use Visual Basic for Applications (VBA) to automate repetitive processes and create tools in Excel. By the end of the course, students will be able to write their own VBA code, modify recorded macros, and enhance efficiency in daily tasks. The course covers topics such as VBA basics, Excel Object Model, creating procedures, working with variables and data types, controlling program flow, creating forms, debugging code, and error-handling. The teaching method includes a 4-part series with practical examples, demonstrations, and exercises. The course is designed for Business Analysts, Data Scientists, and individuals interested in expanding their Excel skills through VBA programming.
Overview
Syllabus
Start
Introduction
Introduction to Debugging Code
Debugging and the Three Types of Errors
Learning About Debugging Tools
Resolving Syntax Errors
Manual Breakpoints - Stepping Into and Out of Code
Manual Breakpoints - Stepping Over Code
Causing Run-Time Errors
Error Trapping Options - On Error Statements
Err Object - Properties and Methods
Writing Error-Trapping Code
Reviewing and Testing On Error GoTo Statement
Writing More Error-Trapping Code
Reviewing and Testing On Error Resume Next Statement
Evaluate the Values of Variables with Locals Window
Watch Window
Tips for Minimizing Errors
Object Browser
Protecting VBA Code
Debugging Code Recap
Conclusion
Taught by
Learnit Training
