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

Video Error

We tried several times to play your video but there was an unforeseen error. We have notified our engineers.

Visit https://helpx.adobe.com/flash-player.html to check that Flash is enabled on your browser.

With Flash enabled, please try again in a few minutes or contact support.

  • Lectures 90
  • Video 8 hours
  • Skill Level All Levels
  • 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 90 lectures and 8 hours of content!

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: Getting Started
Working Files - Download These First
Preview
Article
What Will I Get Out Of This Course
Preview
03:56
The Excel Working Files Explained
Preview
03:00
What Is VBA For Excel?
Preview
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

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?

Visual Basic: Still on Top