arrow_back
Course Tracker
Excel VBA Mastery Program Tracker
Section 01 - Introduction
Why do we learn Excel VBA Macros?
How to learn Excel VBA Macros?
Section 02 - Basic Settings
How to enable Developer Tab in Excel?
Basics of Developer Tab in Excel
Important Macro Security Settings in Excel
How to save Macros in Excel for future use?
Section 03 - Record & Run Macros
How to create a Macros in Excel
How to run a Macro in all open Workbooks
Using a Button to run a Macros in Excel
Running a Macro in different ways in Excel
Understanding VBA Workspace in Excel (Basics)
Watch a Macro being recorded
Section 04 - Google Readymade VBA Codes
Searching Google for VBA Codes - using the 3 magic words
Searching Google for VBA Codes - in Blogs vs Forum
Section 05 - Know Your Workspace
VBA Workspace - a detailed tour
How to increase the font size of the VBA Codes
3 shortcuts to write VBA Codes faster
VBA Code Testing Tricks
Section 06 - Objects, Properties, Methods
Concept of Objects, Properties, Methods in Excel VBA - Part 1
Concept of Objects, Properties, Methods in Excel VBA - Part 2
Concept of Objects, Properties, Methods in Excel VBA - Part 3
Concept of Objects, Properties, Methods in Excel VBA - Part 4
Section 07 - Range & Cells Object
Range and Cells Object in Excel VBA
Example - Using Cells Object with a simple Do-While Loop
What is OFFSET property in Excel VBA
Section 08 - Range Navigation
Range Navigation in Excel VBA (Basics)
Exercise - Finding Last filled Row and Next Row in Excel VBA
Exercise - Finding Last Column No. (English)
Section 09 - Variable Declaration
Variables - Concept, How and Why declare Variables, Initialization
Variables - Data Types
Variables - Best Practices to name Variable
Variables - How to remember to declare Variables (Option Explicit)
Variables - DIM vs SET
Pvt vs Public - Part 1 (English)
Pvt vs Public - Part 2 (English)
Section 10 - Loops
Loops - For Next Loop - Basics
Loops - If Then Else with For Next Loop
Loops - For Each Next - Basics
Loops - If Then Else with For Each Next Loop
Loops - Do While Loop - Basics
Loops - Do Until Loop - Basics
Loops - With Statement
Loops - Select Case - Basics
Section 11 - Input Box & Message Box
Input Box - Basics
Input Box - Inserting user input in a cell
Input Box - Different Value Types
Input Box with IF Then Else Statement
MsgBox Introduction (English)
MsgBox - Part 1 (English)
MsgBox - Part 2 (English)
MsgBox - Part 3 (English)
MsgBox - Part 4 (English)
Section 12 - User Forms
Project 1: Text Box and Command Button - Basics
Project 1: Text Box and Command Button - Designing
Project 1: Text Box and Command Button - Configuring
Project 1: Text Box and Command Button - Load button
Project 2: Option Button and Command Button - Basics
Project 2: Option Button and Command Button - Configuring
Project 3: Option Button in Multiple Clusters (3 ways) - Part 1
Project 3: Option Button in Multiple Clusters (3 ways) - Part 2
Multi Page - Introduction (English)
Multi Page - Part 1 (English)
Multi Page - Part 2 (English)
Multi Page - Part 3 (English)
Check Box - Part 1 (English)
Combo Box - Method 1 (English)
Combo Box - Method 2 (English)
Section 13 - User Defined Functions (UDF)
Basics of User Defind Functions (UDF)
UDF Example 1 – Score Result with IF END IF (English)
UDF Example 2 – Cell Comments (English)
UDF Samples – Series A (English)
UDF Samples – Series B (English)
Section 14 - ActiveX Controls
Form Controls vs ActiveX Controls (English)
MouseMove Event w. Appln Statusbar (English)
Section 15 - Events
Introduction of Events (English)
Events – Workbook_Open and Worksheet_Activate (English)
Exercise 1 – Tracking Workbook Opens (English)
Exercise 2 – Tracking Workbook Save (English)
Event – Worksheet_BeforeDoubleClick (English)
Event – Worksheet_Change (English)
Event – Worksheet_Calculate
Pivot Table – Refresh – WorkSheetActivate (English)
Section 16 - Excel VBA Projects
Excel VBA for Non-Coders Project 1
F&R Text CHR