Visual Basic for Excel - Microsoft VBA Excel Tutorial

Master Visual Basic for Excel, learn to unlock the true power of Excel. Tutorial Taught by a leading Microsoft Expert
  • Lectures 91
  • Video 9 Hours
  • Skill level all level
  • Languages English , captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

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.

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this Visual Basic for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.

The tutorial extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This Visual Basic for Excel tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.

By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn Visual Basic for Microsoft Excel in this video tutorial.

What am I going to get from this course?

  • Over 91 lectures and 8 hours of content!

Curriculum

Section 1: Getting Started
Working Files - Download These First
Text
What Will I Get Out Of This Course
03:56
The Excel Working Files Explained
03:00
Text
Instructions on how to obtain your Certificate of Completion for this Infinite Skills course. All Users of this course are eligible for a Certificate of Completion. Each certificate is issued with a unique number which allows verification that the user has undertaken the course listed. In order to o…
What Is VBA For Excel?
05:07
Excel 2010 Security Settings And Macro Files
03:44
The Developer Ribbon
01:54
Section 2: Macros
Recording And Running A Simple Macro
03:51
Editing An Existing Macro In The Visual Basic Editor
03:59
The New Macro Enabled File Type
02:22
Quick Tour Of The Excel Visual Basic Editor
06:00
Watch A Macro Write Your VBA
02:58
Section 3: Procedures And Functions
What Is A Module?
03:19
Creating A Sub Procedure Manually
03:14
How To Call A Sub Procedure
02:49
Creating A Function Procedure
02:51
How To Call A Function
02:57
Section 4: Getting Started With VBA Programming
Using Comments Within Your VBA Code
03:58
Declaring Variables And Data Types
05:29
The Scope Of A Variable
04:49
The Static Declaration And Variable Expiry
04:53
Constants Instead Of Variables
03:39
An Intrinsic Constant
03:07
String And Date Types Expanded
06:04
Excel VBA Operators
07:50
Arrays
05:07
Multi-Dimensional Arrays
03:32
Dynamic Arrays
03:22
Section 5: Manipulating Excel Objects
Referencing Cells Using The Range Object
05:28
The CELLS Property
02:46
The OFFSET Property
02:29
The VALUE Of Ranges
07:43
The TEXT Object Of The RANGE
03:01
A Number Of Read Only RANGE Properties
09:06
The FONT Property And Colors
08:20
Formatting Numeric Values
03:24
Add Formulas To Cells Through VBA Code
06:36
Common METHODS Of The RANGE Object
11:46
Section 6: Working With Excel VBA Functions
What Is A Function?
01:30
Built In VBA Date Functions
02:29
Text Manipulation With VBA Functions
03:53
Determining File Sizes Using FILELEN
02:34
Using Worksheet Excel Functions In VBA Code
08:09
User Defined Functions In Excel
04:35
Section 7: Controlling Program Flow And Execution
Using GOTO And Labels
04:25
Controlling The Program Flow With IF THEN ELSE
04:23
Multiple Criteria Plus Nested IFs
05:27
Adding ELSEIF To Speed Up Execution
04:07
SELECT CASE As An Alternative To IF
04:24
The FOR NEXT Loop
09:25
FOR NEXT With A VBA Collection
06:32
DO WHILE Loop
06:56
Section 8: Events
How To Create An Event
06:57
WorkBook Events - Open
08:17
Workbook Events - Closing And Saving
07:32
Workbook Triggers - Activate And Deactivate
05:12
Worksheet Triggers - Activate And Deactivate
04:15
Other Useful Worksheet Triggers
09:44
Using Application Events
12:06
Section 9: Debugging And Error Handling
Error Trapping the Easy Way
07:38
Make The VBA Ignore Errors
04:12
Interact With The User When An Error Occurs
04:58
Making Use Of The ERR Object
04:14
Debugging Techniques
06:11
Using Breakpoints To Help Debug
05:45
Setup And Use A Watch
05:04
Speeding Up The VBA Tips
12:50
Section 10: Interacting With Users Through Forms
Using MSGBOX To Interact With Users
09:05
Use INPUTBOX For Accepting Values From Users
07:19
Selecting A Range With The INPUT Box
04:05
An Introduction To UserForms
04:06
Creating A UserForm
04:22
Using Command Buttons In Excel
05:17
Adding Option Buttons In A Frame
05:12
Adding The Code That Makes The Form Work
07:17
Calling Your UserForm And Validating Content
08:05
UserForm Controls - The CheckBox
08:10
UserForm Controls - ListBox And/Or Combo Box
10:10
Images On UserForms
05:24
Labels And Text Boxes
05:30
Multiple Tabs On A UserForm
08:10
Allowing The User To Highlight A Range
04:13
Scrollbar And Spin Controls
08:18
Controlling Tab Order And Aligning Controls
08:48
Section 11: Running And Storing VBA Code
Trigger A Procedure From The Quick Access Toolbar
05:05
Customizing The Ribbons
05:06
Adding Buttons To Sheets
03:51
Adding A Keyboard Shortcut Trigger
02:46
Where To Store Your VBA Code
07:38
Adding Code To The PERSONAL File
08:09
Section 12: Summary
So What's Next?
02:27

Instructor Biography

O'Reilly Media , High Quality Training

O'Reilly spreads the knowledge of innovators through its technology books, online services, magazines, research, and tech conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, O'Reilly has a long history of advocacy, meme-making, and evangelism.

Reviews

Average Rating
4.5
Details
  1. 5 Stars
    42
  2. 4 Stars
    11
  3. 3 Stars
    4
  4. 2 Stars
    2
  5. 1 Stars
    1
    • Owen Hearty

    Great launching pad

    As someone who began their learning of VBA by recording macros and watching what they did, to googling how to do things, this course really helped me pull together everything I had learned and made the skill much more powerful for me. The course was easy to follow, informative, and effective. I find myself coming back to rewatch lessons at time so it's a great ongoing resource.

    • Rick Zadd

    First Udemy Course - Not bad, not great

    This was the first course I ever took on Udemy. I had slightly above average excel skills entering and had done some work recording macros but nothing in the VBA editor. I have some very minor programming background knowledge (the basics of C++ and Java). The good: The course covers a lot. Instruction is usually clear and examples have accompanying code. The bad: From a pedagogy standpoint, this course is not designed with learning in mind. There are no checks for understanding and no chance to really attack a problem on your own, practice, and learn. Frequently I found myself just typing in code that the instructor was typing on screen without really understanding what I was doing. There were a few instances where the instructor skipped a step and the included files did not execute they way the did in the video, but over the course of 91 lectures, I think this happened no more than 4 times. Overall, I think it gave me a decent window into what VBA can do, but left me with very little skill in actually doing it. If I had 0 background with programming I would have been completely lost.

    • Jason Bouligny

    Great Course

    Great Course. Explains most aspects of VBA. I went from a novice to someone who is familiar with most functionality. I just wish it had some information on VBA for Pivot Tables, Charts and how it can interact with other applications within the Microsoft Suite.

    • Olga Timofeyeva

    goal achieved

    Personally I had been procrastinating VBA learning for ages until I had to get this skill for new job. This course encompasses a very comprehensive introduction to VBA with lots of practical recipes for everyday usage. The instructor has astounding presentation skills. He shows real stuff, not reading manual! Thanks, Guy.

    • Luz Garay

    Great course - highly recommend!!

    I have dabbled somewhat in VBA, picking out snippets of code from Internet searches. After taking this course I am very confident that with some continuing ed, I will be able to write VBA code to automate my daily tasks in Excel. Much of what I do is the same, month over month, so the application of the automation that is possible with VBA is very exciting. The instructor was clear and concise, and had great examples. The lessons were relevant and tied together in a very smooth flow. I would certainly take other classes from Guy, and I would highly recommend this course to anyone trying to get started in VBA!

Show more reviews

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,900,000

Hours of video content

22,000,000

Course enrollment

6,500,000

Students

Ready to start learning?
Preview this course