Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel VBA: The VBA Beginner's Blueprint to Programming Excel to your Wishlist.

Add to Wishlist

Excel VBA: The VBA Beginner's Blueprint to Programming Excel

Put Your Work on Autopilot. You're Minutes Away From Learning How To Program Excel!
4.7 (89 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,137 students enrolled
Last updated 1/2017
$10 $175 94% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 5.5 hours on-demand video
  • 41 Articles
  • 92 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
UNDERSTAND why you would want to use VBA in Excel
KNOW the difference between Macros and VBA
CREATE Macros in Excel
MODIFY your Macros
NAVIGATE comfortably in the Visual Basic Editor
LEARN the essentials of writing Excel VBA code
MODIFY your Workbooks using VBA
CREATE Decision Structures in your VBA code
LOOP your VBA code to have it run more than once
CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes
CREATE User Forms from scratch
DEBUG your VBA code
LEARN how to handle errors
CREATE New Worksheet Functions
View Curriculum
  • To get the most out of this course, you should have working knowledge of Microsoft Excel.
  • Excel 2010, 2013, 2016

You Can Finally Put Your Work On Autopilot!

Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should.

Or the day will come when you say, "Oh, I wish there were a better way to do this!"

The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications.

In This Course You Get:

  • Free Downloadable Workbooks - makes it easy to follow along & practice after class.
  • Test Your Skills - exercises to get you engaged & reinforce what you have learned.
  • Code Snippets - with common code bites.
  • VBA Glossary - talk the talk

This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers.

Learning to program can seem daunting at first, but I'm going to make it as easy as possible.

With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course.

But don't stress out.

What I do go over will get you from, "I don't even like looking at VBA", to, "I can do this!"

NOTE: There are multiple ways to get the same result in VBA.

So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K.  

If you're ready to cut your workload, automate your tasks, and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA.

Who is the target audience?
  • This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA.
  • This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 183 Lectures Collapse All 183 Lectures 07:03:23
Welcome to Excel VBA
1 Lecture 02:00

Welcome to this Microsoft Excel VBA course on!

Preview 02:00
Introduction to Visual Basic for Applications
6 Lectures 08:06

Some people write VBA, some record macros, and some do both.
But why?

Preview 02:14

Learn about Object Oriented Programming, your key to VBA.

Understanding Objects

Learn about Container objects in VBA

Containers & Collections

Before you can write VBA, you need to know how VBA refers to objects.

How VBA Refers to Objects

Get familiar with the different security settings that that dictate when your code will run.

Security Settings
2 pages

Key Points for Part One: Introduction to Visual Basic for Applications

Section Summary
Understanding, Recording , and Modifying Macros
12 Lectures 23:49

Learn the steps to successfully record macros in Excel

Preview 04:26

Now that you have recorded a macro, let's make sure it works, and take a look at the VBA code behind it.

Preview 02:59

There are two different modes that you can record you macros in: Absolute and Relative.

Preview 01:55

Now that you know about Relative mode, let's see it in action.

Preview 05:40

What do you do if you need to make a change to you macro?

Preview 03:40

Learn how to create custom keyboard shortcuts for your Excel macros

Assigning Macros to Shortcut Keys
2 pages

Assign your macro to a button on the Quick Access Toolbar.

Accessing Macros through the Quick Access Toolbar
2 pages

Assign your macro to a button on the Ribbon.

Accessing Macros through the Ribbon
1 page

Assign your macro to a shape or to an image.

Accessing Macros through Shapes or Images
1 page

Assign your macro to a button in the Developer toolbox.

Accessing Macros through Command Buttons
1 page

A macro project for quickly navigating through your Excel workbook

Macro Example: Creating Buttons to Navigate Between Worksheets

Key Points for Part Two: Understanding Macros

Section Summary
Getting to Know the Visual Basic Editor
13 Lectures 19:00

Time to write code. Time to get familiar with the Visual Basic Editor.

Preview 02:31

Learn about the Project Explorer in the VBE

Preview 02:11

Learn about the Properties Window in the VBE

Preview 01:46

Learn about the Code Window in the VBE

Preview 04:38

Learn about other important windows in the VBE

Other Windows: the Immediate Window, the Locals Window, and the Watch Window

Windows in the VBE can float, or be docked.

Docking Windows
1 page

Modules are where you will write your VBA. Learn how to add more modules, or remove the modules you know longer need.

Adding and Removing Modules

Knowing how to Export and Import your modules is an important step to maintaining your VBA code.

Exporting and Importing Modules
2 pages

Change the default module name into something more meaningful.

Naming Modules

To be comfortable writing VBA, you need to be comfortable in the VBE.

Learn how to customize the VBE to meet your needs.

Customizing the Visual Basic Environment

Browse through your project's available objects, and see their properties, methods, and events.

The Object Browser
1 page

If you want to lock down your code, here is how you do it.

Protecting Your Code
1 page

Key Points for Part Three: Getting to Know the Visual Basic Editor

Section Summary
Getting Started with Programming VBA
13 Lectures 31:22

An Introduction to Writing VBA

Introduction to Writing VBA

A couple of tips that will help with the speed and accuracy of writing your VBA.

Preview 03:22

Oh oh! Your code has an error in it, and a yellow arrow has appeared - what can you do to keep following along with the exercises?

Preview 02:14

Taking a look at the structure of SubProcedures

Structure of Sub Procedures

Using one SubProcedure inside of another.

Calling a Sub Procedure

Creating Functions

Structure of Functions

Using one Function inside of another.

Calling a Function

How can you call one procedure with the same name as another?

Calling Procedures with the Same Name

Comments can do more than just add notes to your code. Learn another import feature of COmments.

Preview 05:20

Using Objects in Excel VBA

Using Objects

Understanding and using Methods in VBA.

Using Methods

Understanding and using Events in VBA

Using Event Procedures - UPDATED

Key Points for Section: Getting Started with Programming VBA

Section Summary
Getting to Know Variables, Data Types, and Operators
19 Lectures 24:07

Learn about Variables, and how to declare them.


More than likely you are going to be declaring multiple Variables in a procedure, learn how.

Declaring Multiple Variables

Learn about Object Variables in Excel VBA and how it can help you when writing your code.

Object Variables

What are data types, and how can they be used in VBA?

Data Types

You can also declare variable's data types with Identifier Type Characters

Using Identifier Type Characers to Declare Data Types
1 page

Learn how to use Constants

Declaring Constants

A refresher on Arithmetic operators.

Arithmetic Operators
1 page

An exercise using Byte

Exercise: Using Byte Variables
1 page

A description and example of Strings

Exercise: Using String Variables
1 page

A description and example of Currency Variables

Exercise: Using Currency Variables
1 page

A description and example of Date variables

Exercise: Using Date Variables
1 page

A refresher on Logical operators.

Logical Operators
1 page

Learn how to use the Colon operator in VBA

The Colon Operator

Bring multiple strings together with String Contatenation

String Concatenation

When you want to wrap your VBA code around to multiple lines, use the Line Continuation Operator

The Line Continuation Operator

When you want to wrap the text output to multiple lines, use the CRLF.

Carriage Return Line Feed

Using the With statement is a real time saver, find out why.

The With Statement

Scope is an important concept to understand. Learn about the three different kinds of Scope.


Key Points for Section: Getting to Know Variables, Data Types, and Operators

Section Summary
Workbooks, Cells, and Ranges
34 Lectures 01:11:36

Creating an Excel workbook using VBA is easy, but there are a few things you should know.

Creating a New Workbook

Learn the simple lines of VBA code that will open workbooks, close current workbooks, or other workbooks.

Opening and Closing Workbooks

Find out the difference between Worksheets and Sheets.

Worksheets vs. Sheets

Represents the active sheet in the active workbook, or specified workbook.


Learn to add worksheets to your workbooks.

Adding Worksheets

Learn to copy your worksheets.

Copying Worksheets

Learn to use the Move method to organize your Excel workbooks.

Moving Worksheets

Learn to use the Delete method you remove worksheets from your Excel workbooks.

Deleting Worksheets

Learn how to refer to cells in your workbooks

The Cells Object

Follow along with this exercise on using operator and the cells object.

Exercise: Using Operators and the Cells Object

ActiveCell is an important property to know. Learn how you can use it in Excel VBA.


Learn how to use the Rows property to select areas of your Excel workbook.

Rows and Columns

Learn how to insert columns and rows into workbooks

Inserting Columns and Rows

Automatically adjust the width of the columns, or the height of the rows for the best fit.

AutoFit Columns and Rows

Range is one of the most important, and most commonly used Excel VBA objects.

The Range Object

If you have named ranges in your Excel workbook, you can use VBA to change their properties.

Referring to Named Ranges

The Select method is used to select a part of a worksheet.

The Select Method

CurrentRegion is a property of the ActiveCell object.

The CurrentRegion Property

Use the End Property to select the cell at the end of the region that contains data.

The Range.End Property

Learn how to copy information on your worksheet to the clipboard, or to a specified locaion

Copying Data on Your Worksheet

Learn the different ways to use the Pate method in VBA

The Paste Method

Learn to Paste the data that you have copied.

Using PasteSpecial

Font Object Members and examples of their use.

Useful Font Object Members
1 page

Learn how to clear the contents of your cells or ranges.

Clearing Contents and Formats

Represents the name of the object using it.

The Name Property

Represents the data stored in the object, such as a worksheet cell.

The Value Property

In this exercise you will change the worksheet tab’s name to reflect the value in cell A1, when the value in the cell changes.

Exercise: Using Name, and Value

Learn how to Sort the records in your workbooks.

Sorting Fields

Learn how to Filter the records in your workbooks.

Filtering Fields

Learn the simple line of code that allows you to remove duplicate records.

Removing Duplicate Records

Use the PrintPreview method in Excel VBA to display your worksheets in Preview mode.

The PrintPreview Method

Use the PrintOut method in VBA to send your worksheets to your printer.

The PrintOut Method

Key Points for Part Four: Writing VBA Code

Section Summary

Test your skills with this PDF exercise and Excel workbook.

Test Your Skills
4 pages
Formatting Values with Functions
8 Lectures 07:09

Learn how to use Named Format expression to format your values.

The Format Function: Using Named Format Expressions

Learn to use the Format Function to create Custom Number Formats

The Format Function: Creating Custom Number Formats
3 pages

Learn to use the Format Function to create Custom Date/Time Formats

The Format Function: Creating Custom Date/Time Formatting
2 pages

Learn to use the Format Function to create Custom String Formats

The Format Function: Creating Custom String Formats
1 page

Format Currency values with the FormatCurrency function.

Using the FormatCurrency Function

The FormatNumber format works similarly to FormatCurrency, the difference being no currency symbol is returned.

The FormatNumber Function

Learn how to use the FormatDateTime function

Using the FormatDateTime Function
1 page

The FormatPercent format works similarly to FormatCurrency, and FormatNumber.
The difference being that the number is formatted as a percentage with a trailing % character.

The FormatPercent Function
Using Decision Structures to Branch Your VBA Code
5 Lectures 13:04

An Introduction to Control Structures

Introduction to Decision Structures

The If…Then statement is a simple control that tests whether a condition is true or false.


With an If…Then…Else statement, the control can take a secondary course of action. If the condition is true, then an action occurs. If the condition is false, take an alternate action.


When you have a large number of conditions to examine, the If…Then…Else statement will go through each one of them. Visual Basic offers the option of jumping to the statement that applies to the state of a condition.

Select Case

Key Points for Part Five: Control Structures

Section Summary
Looping Your VBA Code
18 Lectures 42:34

What do you think of the course so far?
Is it helpful?
Please leave a Review, or a Star Rating, letting other students know about the course.

How Are You Enjoying the Course?
1 page

A loop is a sequence of instructions that is continually repeated until a certain condition is reached.

Introduction to Loops

If you know with certainty how many times you want to execute a statement, you can use the For...Next expression.

For Next Loop

You will create a simple procedure that executes a For…Next loop that populates data into the first six rows of a worksheet.

Exercise: For Next Loop

If you want to control how the incrementing processes, you can set your own, using the Step option.


  1. How can you use a For...Next loop to insert 11 additional worksheets in your workbook?
  2. How can you use a For...Next loop to print preview the first 3 worksheets in your workbook?
Quick Questions: For Next Loops

Answers to the questions in the previous lecture.

Quick Answer: For Next Loops

For Each loops are typically used with collections and arrays

For Each

In this example you want to remove the hyphens from each cell in the A column.

Exercise: For Each, Example 1

A continuation of the previous For Each lecture

Exercise: For Each, Example 2

You can also exit a For loop. To do this, in the section where you want to stop, type Exit For.

Exiting a For Loop

The Do Until loop repeatedly executes a section of code until a specified condition evaluates to True.

Do Until Loop

An example of using a Do Until Loop

Exercise: Do Until Loops

The Do While loop repeatedly executes a section of code while a specified condition continues to evaluate to True.

Do While Loop

An example of using a Do While Loop

Exercise: Do While Loop

You can also exit a Do loop. To do this, in the section where you want to stop, type Exit Do.

Exiting a Do Loop

Key Points for Part Six: Loops

Section Summary

Test your Looping skills with this PDF exercise and Excel workbook.

Test Your Skills
4 pages
6 More Sections
About the Instructor
4.6 Average rating
667 Reviews
13,929 Students
16 Courses
Computer Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.

Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, because Change Matters, Growth Matters.

Report Abuse