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