Description
In this course, you will learn the basics of Visual Basic for Applications (VBA) and Object Orientated Programming. The course starts off with an introduction to the course content, and an overview of VBA and OOP.
In the first module, you will learn about Macros Initial Setup, including how to record and save a macro. In the second module, you will dive deeper into VBA, learning about variables and procedures. Topics covered in this module include variables, variable exercise, message boxes, input boxes, basic navigation, and sheets.
In the third module, you will learn about Loop and IF statements, as well as error handling and debugging. This module covers operators, automation, for loops, do loops, IF statements, and select case.
The course also includes a section on User Defined Functions and Form Controls, and a final section on test your knowledge, with exercises to test your understanding of the material covered in the course.