Excel VBA Programming - The Complete Guide

This episode introduces you to the course and Excel VBA programming. You'll then explore the developer tab, different Excel files, macro security, and visual basic editor interface. You'll also distinguish between absolute and relative references.

In this episode, you'll discover the role of object-oriented programming in Excel VBA.

In this episode, you'll go through the features of visual basic editor and learn how to create and delete a procedure.

This episode will show you how to invoke methods with and without arguments and with multiple arguments. In addition to this, you'll use an object browser to access online documentation and learn different ways to invoke a procedure.

The episode starts with syntax tips that'll help you to write clean VBA code. You'll then become familiar with variable declarations and get to grips with different data types and mathematical operations.

In this episode, you'll explore different types of variable and procedure scope and learn how to call a procedure from another procedure. You'll also handle and terminate a procedure and learn how to replace variables with constants.

This video will help you to understand the Excel object hierarchy in detail and you'll learn how to effectively use different workbook properties and methods such as add, close, move, and delete.

In this episode, you'll deep dive into the concepts of Range. You'll explore the value and text properties on the Range object and get to grips with different Range properties such as offset, resize, cells, row, and column. You'll also find out the role of R1C1 notation in VBA.

This episode will make you familiar with different types of methods and properties such as fill down, replace, text to columns, sort, interior, and autofit.

In this episode, you'll become well-versed with conditional statements of Excel VBA such as Boolean expressions, if then statements, elseif and else statements, select cases, AND & OR logical operators, and the Not operator.

In this episode, you'll find out how to use for loop and the step keyword to iterate a certain block of instructions a given number of times. You'll also learn how to use the With-End With construct to overwrite multiple properties on an object. This episode also teaches you how to terminate a for loop.

In this episode, you'll get a solid understanding of the MsgBox method.

In this episode, you'll explore arrays and their different syntaxes such as lower bound and upper bound. You'll also learn how to initialize arrays within a for loop.

In this episode, you'll deep dive into the VBA functions.

In this episode, you'll find out some common errors that occur in VBA code and how to catch them using the techniques of error handling.

This episode shows you how to handle different events that trigger VBA procedures.

In this episode, you'll learn how to create a user form and configure it with labels, text boxes, buttons, and more.