Microsoft Excel VBA for Beginners - Learn VBA Step by Step

In this video you'll learn a little about why I'm here teaching you, how VBA is helpful in making your work in Excel more efficient, and some tips for getting the most out of this course.

In this lecture you will learn when you use VBA and how it can be helpful for speeding up your work in Excel.

This video will teach you how to set up VBA in Excel so that you have VBA available to use in your workbooks. This includes activating the Developer tab in your Excel ribbon.

Let's dive into the basics of VBA. This video covers the VBA window itself, what the various buttons do, what a module/form is, and how to search the object library.

This video shows you how to record a macro to quickly automate short procedures or get an example of what the code might be for a particular action. This is where the fun begins.

This video covers how to create a subroutine and the differences between public and private subs.

This video will teach you the different types of variables (string, integer, long, etc.) and what they are.

This lecture will teach you how to declare a variable as well as the difference between global and local variables.

This video will show you how to build message/alert boxes for the user to interact with, how to change the buttons on those boxes, how to use input boxes, and how to turn off alert messages.

In this video you'll learn what Arrays are and what we use them for.

A static array has a pre-set size, meaning we tell the system how many items to expect in that list. They are useful when you know ahead of time exactly how many data points you will have.

Dynamic arrays will grow or shrink to accommodate however much data you have in your code.

Multi-dimensional arrays allow you to put multiple columns or rows into one array in your VBA code.

In this video you'll learn how to create a GUI, or Graphical User Interface, for your user to interact with so they aren't getting into your code.

Object hierarchy describes which objects take priority over other objects in Excel VBA.

In this lecture you'll learn about the workbooks and worksheets objects in Excel (e.g. how to switch between workbooks/worksheets or save them).

In this lecture you'll continue to learn about the workbooks and worksheets objects in Excel.

In this lecture you'll learn about worksheet objects. Worksheet objects allow you to add, delete, rename and do other actions to your worksheets within your Excel workbook using VBA.

In this lecture you learn how to pull data from the Excel file or how to write new data to the Excel file using VBA.

In this lecture you'll learn the importance of tables and how to name and use them to prepare for use in VBA.

In this lecture you'll learn about adding/deleting columns and rows and other basic table interactions using VBA.

This lecture covers the basics of how to work with numbers and perform math in VBA correctly and accurately.

This lecture covers the basics of text in VBA and how you can manipulate text strings to limit them, search within them, or combine them.

Creating and calling subroutines is all about work flow management. In this video you'll learn how to break up your code in a way that makes it easier to use and easier to edit.

There is a pair of parentheses next to your subroutine that you can place information into, like a variable or a string, that will then pass into your sub. You'll learn how to do that in this video.

In this lecture you'll learn about the various types of loops (such as For Each/Next or Do Until) as well as If-Then statements and what they do in VBA.

In this lecture you'll learn about the use of With/End With to quickly work with the same set of properties without having to continually retype the object hierarchy.

This video goes through examples of the different types of loops and how you might use them in practice.

In this lecture, we'll walk through the various types of controls that appear on a form and what they do/mean.

This video demonstrates the different properties that are associated with each control, including tab order.

This lecture goes over how to open up the form code window and what features you can build into your form.

This lecture shows how to build list/combo boxes and how to pre-load values and lists into your form when it opens.

This video covers quick fixes and rules of thumb for helping your code run quickly and efficiently.

This video goes over the most common types of bugs and how you might recognize them in your code.

This video will cover the intrinsic debug tools built into VBA like the stepping through code via breakpoint, watch windows, stepping through your code, etc.

This video covers the various error statements you can use in VBA to catch and address errors your code encounters to communicate to the user what the problem might be and make a decision about whether or not to finish executing the code.

This lecture discusses custom functions in Excel and how to build custom workbook functions using VBA.

This lecture shows you how to build events into your workbook file to run macros automatically in the background (such as when a certain cell is changed, when a cell is double clicked, etc.)