Visual Basic for Excel - Microsoft VBA Excel Tutorial
4.4 (1,601 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
13,739 students enrolled

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
4.4 (1,601 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
13,739 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
English
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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.

Course content
Expand all 90 lectures 08:06:48
+ Macros
5 lectures 19:10
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
+ Procedures And Functions
5 lectures 15:10
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
+ Getting Started With VBA Programming
11 lectures 51:50
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
+ Manipulating Excel Objects
10 lectures 01:00:39
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
+ Working With Excel VBA Functions
6 lectures 23:10
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
+ Controlling Program Flow And Execution
8 lectures 45:39
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
+ Events
7 lectures 54:03
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
+ Debugging And Error Handling
8 lectures 50:52
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
+ Interacting With Users Through Forms
17 lectures 01:53:31
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