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 (64 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.
1,847 students enrolled
$19
$175
89% off
Take This Course
  • Lectures 183
  • Length 7 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course Description

*UPDATED: Nov. 8, 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.


What are the requirements?

  • To get the most out of this course, you should have working knowledge of Microsoft Excel.
  • Excel 2010, 2013, 2016

What am I going to get from this course?

  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome to Excel VBA
02:00

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

Section 2: Introduction to Visual Basic for Applications
02:14

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

02:34

Learn about Object Oriented Programming, your key to VBA.

01:06

Learn about Container objects in VBA

01:11

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

2 pages

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

Article

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

Section 3: Understanding, Recording , and Modifying Macros
04:26

Learn the steps to successfully record macros in Excel

02:59

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

01:55

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

05:40

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

03:40

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

2 pages

Learn how to create custom keyboard shortcuts for your Excel macros

2 pages

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

1 page

Assign your macro to a button on the Ribbon.

1 page

Assign your macro to a shape or to an image.

1 page

Assign your macro to a button in the Developer toolbox.

03:59

A macro project for quickly navigating through your Excel workbook

Article

Key Points for Part Two: Understanding Macros

Section 4: Getting to Know the Visual Basic Editor
02:31

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

02:11

Learn about the Project Explorer in the VBE

01:46

Learn about the Properties Window in the VBE

04:38

Learn about the Code Window in the VBE

02:04

Learn about other important windows in the VBE

1 page

Windows in the VBE can float, or be docked.

02:04

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

2 pages

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

01:34

Change the default module name into something more meaningful.

01:02

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

Learn how to customize the VBE to meet your needs.

1 page

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

1 page

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

Article

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

Section 5: Getting Started with Programming VBA
00:23

An Introduction to Writing VBA

03:22

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

02:14

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?

01:36

Taking a look at the structure of SubProcedures

03:38

Using one SubProcedure inside of another.

03:09

Creating Functions

01:10

Using one Function inside of another.

Article

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

05:20

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

03:00

Using Objects in Excel VBA

03:29

Understanding and using Methods in VBA.

02:49

Understanding and using Events in VBA

Article

Key Points for Section: Getting Started with Programming VBA

Section 6: Getting to Know Variables, Data Types, and Operators
06:59

Learn about Variables, and how to declare them.

Article

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

02:34

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

02:13

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

1 page

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

02:39

Learn how to use Constants

1 page

A refresher on Arithmetic operators.

1 page

An exercise using Byte

1 page

A description and example of Strings

1 page

A description and example of Currency Variables

1 page

A description and example of Date variables

1 page

A refresher on Logical operators.

Article

Learn how to use the Colon operator in VBA

Article

Bring multiple strings together with String Contatenation

Article

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

01:39

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

Article

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

05:47

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

Article

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

Section 7: Workbooks, Cells, and Ranges
03:36

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

02:26

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

02:12

Find out the difference between Worksheets and Sheets.

Article

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

04:18

Learn to add worksheets to your workbooks.

02:42

Learn to copy your worksheets.

Article

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

Article

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

02:27

Learn how to refer to cells in your workbooks

01:39

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

04:41

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

02:47

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

Article

Learn how to insert columns and rows into workbooks

Article

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

01:20

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

01:56

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

Article

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

02:24

CurrentRegion is a property of the ActiveCell object.

04:25

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

03:42

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

04:25

Learn the different ways to use the Pate method in VBA

03:28

Learn to Paste the data that you have copied.

1 page

Font Object Members and examples of their use.

03:30

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

Article

Represents the name of the object using it.

Article

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

01:35

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.

03:50

Learn how to Sort the records in your workbooks.

07:41

Learn how to Filter the records in your workbooks.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

IsáBel Harrison, 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.


Ready to start learning?
Take This Course