Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel VBA Tutorials - Learn VBA with a practical approach
Instructions Manual
Course Manual
Downloadable Files:
Downloadable Working files and Case studies
INTRODUCTION 1
Why learn Macros? (4:17)
Activate "Developer" tab (2:02)
Saving a Macro-enabled WorkBook (XLSM) (2:53)
Macro Security Settings (2:13)
Course Feedback
Developer tab - Essential Buttons (0:54)
Head & Tail of a Macros (Sub Procedure & User Defined Function) (4:01)
"Click Here" button to run a Macro (1:46)
Excel VBA Macro Quiz #1
INTRODUCTION 2
Macros - Record & Run (5:08)
Macros - Viewing the code (2:41)
Macro-free vs. Macro-enabled Workbook (0:55)
Visual Basic Editor (VBE) (3:18)
Personal Macro WB (5:20)
Ways to Run a Macro (2:47)
Course Feedback
Excel VBA Macro Quiz #2
GOOGLE
Using Google to locate useful VBA codes - 1 (7:43)
Using VBE and Macro Recorder to customize Macro code (4:46)
Using Google to locate useful VBA codes - 2 (6:29)
Course Feedback
OBJECTS, PROPERTIES, METHODS
Objects, Properties, Values, Methods and Parameters 1 (2:19)
Objects, Properties, Values, Methods and Parameters 2 (1:58)
Course Feedback
Excel VBA Macro Quiz #3 - OBJECTS, PROPERTIES, METHODS
WORKSPACE
Code Color & Activating Edit Toolbar w. Comments (3:00)
Edit Toolbar - Indent, Bookmark (1:49)
Code writing shortcuts incl. Intellisense (1:58)
Testing the Code (2:58)
Immediate Window 01 (3:06)
Course Feedback
Excel VBA Macro Quiz #4 - WORKSPACE
RANGE & CELLS OBJECT
Range Selection - Method 1 (4:56)
Range Selection - Method 2 & 3 (3:21)
Advantage of Range Selection - Method 2 & 3 (5:49)
Range Selection (Rows & Columns) - Method 4 (0:54)
Assigning values to selected range of cells (2:01)
Exercise 1 - Assigning values to selected range of cells (1:35)
Exercise 2- Assigning values to selected range of cells (0:45)
Multiple Range Selection - Method 5 (2:01)
Multiple Range Selection - Method 6 (2:20)
Range Selection Ways - Others (2:04)
Course Feedback
Excel VBA Macro Quiz #5_1 - RANGE & CELLS OBJECT
Excel VBA Macro Quiz #5_2 - RANGE & CELLS OBJECT
Excel VBA Macro Quiz #5_3 - RANGE & CELLS OBJECT
ABSOLUTE vs RELATIVE REFERENCE
Offset - Basics (1:53)
Using Relative Reference in Macros (3:11)
Course Feedback
Excel VBA Macro Quiz #6 - ABSOLUTE vs RELATIVE REFERENCE
RANGE NAVIGATION
Navigating between a range of cells - Part 1 (2:14)
Navigating between a range of cells - Part 2 (1:20)
Navigating between a range of cells - Part 3 (1:50)
Exercise - Finding Last Row No. (4:17)
Exercise - Finding Last Column No. (3:42)
Exercise - Finding Next Row No. (1:25)
Course Feedback
Excel VBA Macro Quiz #7 - RANGE NAVIGATION
VARIABLE DECLARATION
Variable Decl 01 (4:27)
Variable Decl 02 (2:03)
Pvt vs Public 01 (2:16)
Pvt vs Public 02 (5:32)
Option Explicit (4:29)
Difference - DIM vs. SET (2:03)
Course Feedback
Excel VBA Macro Quiz #8 - VARIABLE DECLARATION
LOOPS
"For...Next" (3:27)
"If...Else...End If" nested within "For...Next" (5:23)
"Do…While" (7:32)
"Do…Until" (3:00)
"For Each...Next" (4:08)
"If...End If" nested within "For Each...Next" (4:46)
Exercise - "Do While" and Loop Counter (11:56)
"With…End With" - Example 1 (1:26)
"With…End With" - Example 2 (2:37)
"Select…Case" - Demonstration (2:21)
"Select…Case" - Explanation (5:18)
Course Feedback
Excel VBA Loop - Macro Quiz #9
OPTIMIZING CODE EFFICIENCY
Speed up the code running - 1 (3:16)
Speed up the code running - 2 (2:34)
Speed up the code running - 3 (2:22)
Course Feedback
Excel VBA Macro Quiz #10 OPTIMIZING CODE EFFICIENCY
EVENTS
Introduction (1:49)
Events - Workbook Open and Worksheet Activate (4:40)
Exercise 1 - Tracking Workbook Opens (8:27)
Exercise 2 - Tracking Workbook Save (3:46)
Event - Worksheet Before Double Click (6:53)
Event - Worksheet Change (4:37)
Event - Worksheet Calculate (2:41)
Pivot Table - Refresh - Work Sheet Activate (3:55)
Course Feedback
Excel VBA Macro Quiz #11 Events
INPUT BOX
Introduction (2:33)
Input Box - 1 (5:11)
Input Box - 2 (5:36)
Input Box - 3 (2:54)
Input Box - 4 (6:53)
Course Feedback
Excel VBA Macro Quiz #12 INPUT BOX
MSG BOX
Introduction to Msg box in excel vba (1:35)
MsgBox - 1 (3:48)
MsgBox - 2 (6:26)
MsgBox - 3 (1:23)
MsgBox - 4 (2:17)
Course Feedback
Excel VBA Macros Quiz #13_1 MSG Box
Excel VBA Macros Quiz #13_2 MSG Box
ACTIVEX CONTROLS
Form Controls vs ActiveX Controls (3:49)
MouseMove Event w. Appln Statusbar (4:44)
Excel VBA Macros Quiz #14 ACTIVEX CONTROLS
USER FORMS
Introduction (1:03)
User Form - Basics (3:44)
Exercise - Part 1 of 4 (1:44)
Exercise - Part 2 of 4 (6:16)
Exercise - Part 3 of 4 (3:59)
Exercise - Part 4 of 4 (11:21)
Option Button - 1 (5:12)
Option Button - 2 (6:17)
Multi Page - Introduction (1:35)
Multi Page - 1 (5:46)
Multi Page - 2 (3:21)
Multi Page - 3 (6:33)
Check Box 01 (6:37)
Combo Box - Method 1 (2:20)
Combo Box - Method 2 (4:57)
Excel VBA Macros Quiz #15_1 USER FORMS
Excel VBA Macros Quiz #15_2 USER FORMS
Excel VBA Macros Quiz #15_3 USER FORMS
USER DEFINED FUNCTIONS
UDF Intro 01 (2:56)
UDF Example 1 - ScoreResult with IF END IF (3:53)
UDF Example 2 - CellComments (4:04)
UDF Samples - Series A (4:56)
UDF Samples - Series B (0:59)
Excel VBA Macros Quiz #16 USER DEFINED FUNCTIONS
MIS PROJECTS
Split Workbook (9:10)
Protect - Unprotect Sheets (3:10)
Index of Hyperlinks to all Sheets (5:27)
Extract all Comments of a WorkBook to a new WorkSheet (7:04)
Project- Automate,Comment,Insertion and Extraction (3:54)
Count Cells by Color (3:08)
Combine WorkSheets (7:34)
Case Study
01 Case Study- Intro (2:00)
02 Case Study - Demo (4:11)
03 Create the first UserForm (6:48)
04 Write the first line of code (3:26)
05 VBA code to match Username and Password (5:15)
06 Continue with UserForm (4:44)
07 VBA code for the second UserForm (4:49)
08 Unload and Hide UserForm (2:34)
09 Setting of the third UserForm (8:01)
010 Validation for the third UserForm - Part 1 (2:53)
011 VBA code to enable a button (4:20)
012 Validation for the third UserForm - Part 2 (5:02)
013 VBA code for the third UserForm (7:45)
014 Configuring the Previous button (1:47)
015 Submit Data and hide content in excel sheet (5:11)
016 Capture data from the UserForm (3:47)
017 Create a Table Format (3:29)
018 VBA code to send Email (3:25)
019 Send an Email (2:54)
020 Finishing touch to the project (5:44)
021 Testing the code (3:14)
Excel VBA Macro Quiz #11 Events
Q 1
Complete and Continue