Excel VBA: The VBA Beginner's Blueprint to Programming Excel
4.5 (146 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,395 students enrolled
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

You're Minutes Away From Learning How To Program Excel!
4.5 (146 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,395 students enrolled
Created by Isá Harrison
Last updated 7/2017
English
Current price: $10 Original price: $175 Discount: 94% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 41 Articles
  • 94 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • To get the most out of this course, you should have working knowledge of Microsoft Excel.
  • Excel 2010, 2013, 2016
Description

Become an Excel Programmer and 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
183 Lectures
07:03:21
+
Welcome to Excel VBA
1 Lecture 02:00

Welcome to this Microsoft Excel VBA course on Udemy.com!

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
02:34

Learn about Container objects in VBA

Containers & Collections
01:06

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

How VBA Refers to Objects
01:11

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
01:01
+
Understanding, Recording , and Modifying Macros
12 Lectures 23:48

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
03:59

Key Points for Part Two: Understanding Macros

Section Summary
01:09
+
Getting to Know the Visual Basic Editor
13 Lectures 18:37

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
02:04

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
02:04

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
01:34

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
01:02

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
00:47
+
Getting Started with Programming VBA
13 Lectures 31:22

An Introduction to Writing VBA

Introduction to Writing VBA
00:23

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
01:36

Using one SubProcedure inside of another.

Calling a Sub Procedure
03:38

Creating Functions

Structure of Functions
03:09

Using one Function inside of another.

Calling a Function
01:10

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

Calling Procedures with the Same Name
00:24

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
03:00

Understanding and using Methods in VBA.

Using Methods
03:29

Understanding and using Events in VBA

Using Event Procedures - UPDATED
02:49

Key Points for Section: Getting Started with Programming VBA

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

Learn about Variables, and how to declare them.

Variables
06:59

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

Declaring Multiple Variables
00:21

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

Object Variables
02:34

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

Data Types
02:13

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
02:39

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
00:07

Bring multiple strings together with String Contatenation

String Concatenation
00:03

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

The Line Continuation Operator
00:18

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

Carriage Return Line Feed
01:39

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

The With Statement
00:28

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

Scope
05:47

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

Section Summary
00:57
+
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
03:36

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

Opening and Closing Workbooks
02:26

Find out the difference between Worksheets and Sheets.

Worksheets vs. Sheets
02:12

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

ActiveSheet
00:09

Learn to add worksheets to your workbooks.

Adding Worksheets
04:18

Learn to copy your worksheets.

Copying Worksheets
02:42

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

Moving Worksheets
00:08

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

Deleting Worksheets
00:06

Learn how to refer to cells in your workbooks

The Cells Object
02:27

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

Exercise: Using Operators and the Cells Object
01:39

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

ActiveCell
04:41

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

Rows and Columns
02:47

Learn how to insert columns and rows into workbooks

Inserting Columns and Rows
00:08

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

AutoFit Columns and Rows
00:17

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

The Range Object
01:20

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

Referring to Named Ranges
01:56

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

The Select Method
00:09

CurrentRegion is a property of the ActiveCell object.

The CurrentRegion Property
02:24

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

The Range.End Property
04:25

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

Copying Data on Your Worksheet
03:42

Learn the different ways to use the Pate method in VBA

The Paste Method
04:25

Learn to Paste the data that you have copied.

Using PasteSpecial
03:28

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
03:30

Represents the name of the object using it.

The Name Property
00:07

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

The Value Property
00:11

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
01:35

Learn how to Sort the records in your workbooks.

Sorting Fields
03:50

Learn how to Filter the records in your workbooks.

Filtering Fields
07:41

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

Removing Duplicate Records
03:39

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

The PrintPreview Method
00:13

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

The PrintOut Method
00:42

Key Points for Part Four: Writing VBA Code

Section Summary
00:40

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
03:41

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
03:14

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

The FormatNumber Function
00:05

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
00:08
+
Using Decision Structures to Branch Your VBA Code
5 Lectures 13:04

An Introduction to Control Structures

Introduction to Decision Structures
00:48

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

If…Then
04:02

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.

If…Then…Else
02:37

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
05:19

Key Points for Part Five: Control Structures

Section Summary
00:18
+
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
01:03

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

For Next Loop
03:49

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
04:39

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

Stepping
02:08

  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
00:12

Answers to the questions in the previous lecture.

Quick Answer: For Next Loops
00:07

For Each loops are typically used with collections and arrays

For Each
01:29

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

Exercise: For Each, Example 1
03:19

A continuation of the previous For Each lecture

Exercise: For Each, Example 2
06:35

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
02:34

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

Do Until Loop
01:33

An example of using a Do Until Loop

Exercise: Do Until Loops
07:18

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

Do While Loop
01:11

An example of using a Do While Loop

Exercise: Do While Loop
03:39

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
02:20

Key Points for Part Six: Loops

Section Summary
00:37

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

Test Your Skills
4 pages
6 More Sections
About the Instructor
Isá Harrison
4.6 Average rating
948 Reviews
15,271 Students
16 Courses
Results & Convenience | 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.