Ultimate Excel VBA Macros Training Course

An introduction to VBA, an its applicable uses for finance professionals

In this lesson we will look at how to navigate through the visual basic for applications window

In this lesson we will look at what macros are, and how to access the macros window from the developer tab

In this lesson we explain what the relationship is between macros and VBA

A brief overview of pre-requisite knowledge to ensure the student is properly prepared for the course material ahead.

In this lesson the student will learn about the offset formula and its usefulness.

This lesson goes further in detail regarding the offset function and its interaction between functions such as SUMIF and CountA.

In this lesson, we will look at what VBA modules and sub-procedures are.

This lesson will look at the differences between functions and sub-procedures.

In this lesson we will look at how we can create subprocedures for basic tasks.

In this lesson we will look at how we can create subprocedures for basic tasks.

This lesson will explain the VBA object explorer and how to use it

This lesson will describe properties and their contents.

This lesson will explain the data types and how variables work in VBA.

This lesson will explain calculations in VBA with some examples.

In this lesson we will look at the hierarchy of VBA and where objects lie within this hierarchy.

This lesson we will explain more about objects and how they work.

This lesson will teach students how to create a shape and record the actions with the record macro command

This lesson will help students to understand how range and selecting works in VBA.

This lesson will outline the weaknesses of the record macro and why it is only an entry level tool

This lesson will outline what statements are, and the different types of statements.

This lesson will teach you some programming tools that will make your code more efficient, and allow you to get away with writing fewer lines of code while achieving the same result.

In this lesson the student will learn about keywords within VBA, and the different types of keyword operators. Additionally, there is a lesson regarding constants located in the resources for additional information.

This lesson will explain defining variables and the range command

This lesson will describe the data types of strings and integers

This lesson discusses variables and arrays

This lesson discusses VBA expressions

This lesson discusses how to create conditional dynamic loops, tools that allow one to iterate through data and / or objects

This lesson will describe with statements and how they function

This lesson will describe how to refer to the currently open workbook as well as how to navigate through sheets with VBA

This lesson will walk through a sub on how to open all workbooks

This lesson shows how to refer to a worksheet within the same workbook the macro is created in

This lesson will go over a variables and how to define them. Additionally, there are resources downloadable in this lesson to better understand operators and constants.

This lesson will go over how a for next loop works

This lesson will go over how the for each next loop works

In this lesson students will learn about the workbook object. There is also an introduction to VBA objects article located in the resources section.

This lesson will describe worksheets as objects and how to think about them

In this lesson we will learn about the active cell column and row commands

This lesson will discuss the active window command and its associated properties that you can reference

This lesson will describe the active sheet command and its associated properties related to its sub categories

This lesson will show you how to utilize a couple features of the columns and rows properties of the worksheet object

This lesson will explain boolean values and how they work. There is also additional material on the select command included in the resources.

In this lesson we will look at the 'this workbook' command; to learn how to reference the current workbook that the macro you are creating is running in

This lesson will introduce the concept of error handling, and its uses

This lesson will illustrate the uses of the local, immediate and watch windows that are available in VBA to help one debug their code

This lesson will discuss the if worksheet command and how/when to use it

This lesson will discuss the on error command and what it is capable of doing

This lesson impresses upon students the usefulness of for each and if commands in the process of automating tasks. There is also a lesson resource regarding default commands in absence of selection in the resources section.

This lesson discusses the next and last commands with regard to iterating through objects

This lesson will demonstrate the offset command, as well as the range command and the uses, limitations and differences between the two.

In this lesson we will show the message box function, how it works and an example of how to use it.

This lesson shows how to create an input box and its uses. Additionally, regular expressions and utilizing different patterns has been added into the resource section.

This lesson will teach you about the different userform tools that you can use to create your own userform

In this lesson we will learn about userforms and how to crate them for entering data

This lesson will discuss linking developer control objects to their modules

This lesson goes over creating a userform for data input from scratch using a purchase invoice as an example

This lesson will talk about how to structure custom sub procedures; attached in the resources is also a trim function example

This lesson will look at convering a dynamic range selected with an input box and turning these cells into string data. There are two additional resources attached regarding auto adjusting rows and columns as well as learning how to combine all workbooks with VBA

This lesson will show you how to rename all worksheets based on cell values in VBA

This lesson will teach you how to add all values in a worksheet into another sheet

This lesson will teach you how to find and replace different types of characters with the RegEx function

This lesson will teach you how to create custom functions with VBA

This lesson will teach you different ways to comment out functions and the limitations of functions at the sheet level

This lesson will look at using the DDB function in VBA

This lesson will look at the PV and NPV functions in VBA

This lesson will show you how to create a commission calculating function