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:20)
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:01)
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:20)
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:53)
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:53)
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:23)
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:44)
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:17)
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: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: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:50)
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
Introduction to Msg box in excel vba
Demo of different types of MsgBox
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login