Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Macro Tutorial – Free Online Tutorial
Instructions Manual
Manual
Introdunction
Why learn Macros? (4:17)
Activate "Developer" tab (2:02)
Saving a Macro-enabled WorkBook (XLSM) (2:53)
Macro Security Settings (2:13)
Developer tab - Essential Buttons (0:54)
Head & Tail of a Macros (Sub Procedure & User Defined Function) (4:00)
"Click Here" button to run a Macros 🔒
Get a Full Version now!
Review our Course
INTRODUCTION 2
Macros - Record & Run (5:07)
Macros - Viewing the code 🔒
Macro-free vs. Macro-enabled Workbook 🔒
Visual Basic Editor (VBE) 🔒
Personal Macro WB 🔒
Ways to Run a Macros 🔒
GOOGLE
Using Google to locate useful VBA codes - 1 (7:42)
Using VBE and Macro Recorder to customise Macro code 🔒
Using Google to locate useful VBA codes - 2 🔒
OBJECTS, PROPERTIES, METHODS
Objects, Properties, Values, Methods and Parameters 1 🔒
Objects, Properties, Values, Methods and Parameters 2 (2:02)
WORKSPACE
Code Color & Activating Edit Toolbar w. Comments 🔒
Edit Toolbar - Indent, Bookmark 🔒
Code writing shortcuts incl. Intellisense 🔒
Testing the Code 🔒
Immediate Window 01 🔒
RANGE & CELLS OBJECT
Range Selection - Method 1 🔒
Range Selection - Method 2 & 3 🔒
Advantage of Range Selection - Method 2 & 3 🔒
Range Selection (Rows & Columns) - Method 4 🔒
Assigning values to selected range of cells 🔒
Exercise 1 - Assigning values to selected range of cells 🔒
Exercise 2- Assigning values to selected range of cells 🔒
Multiple Range Selection - Method 5 🔒
Multiple Range Selection - Method 6 🔒
RangeSelectionWays - Others 🔒
ABSOLUTE vs RELATIVE REFERENCE
Offset - Basics 🔒
Using Relative Reference in Macros 🔒
RANGE NAVIGATION
Navigating between a Range of cells - Part 1 🔒
Navigating between a Range of cells - Part 2 🔒
Navigating between a Range of cells - Part 3 🔒
Exercise - Finding Last Row No. 🔒
Exercise - Finding Last Column No. 🔒
Exercise - Finding Next Row No. 🔒
VARIABLE DECLARATION
Variable Decl 01 🔒
Variable Decl 02 🔒
Pvt vs Public 01 🔒
Pvt vs Public 02 🔒
Option Explicit 🔒
Difference - DIM vs. SET 🔒
LOOPS
"For...Next" 🔒
"If...Else...End If" nested within "For...Next" 🔒
"Do…While" 🔒
"Do…Until" 🔒
"For Each...Next" 🔒
"If...End If" nested within "For Each...Next" 🔒
Exercise - "Do While" and Loop Counter 🔒
"With…End With" - Example 1 🔒
"With…End With" - Example 2 🔒
"Select…Case" - Demonstration 🔒
"Select…Case" - Explanation 🔒
OPTIMIZING CODE EFFECIENCY
Speed up the code running - 1 🔒
Speed up the code running - 2 🔒
Speed up the code running - 3 🔒
EVENTS
Introduction 🔒
Form Controls vs ActiveX Controls 🔒
Events - Workbook_Open and Worksheet_Activate (4:39)
Exercise 1 - Tracking Workbook Opens 🔒
Exercise 2 - Tracking Workbook Save 🔒
Event - Worksheet_BeforeDoubleClick 🔒
Event - Worksheet_Change 🔒
Event - Worksheet_Calculate 🔒
Pivot Table - Refresh - WorkSheetActivate 🔒
INPUT BOX
Introduction 🔒
Input Box - 1 🔒
Input Box - 2 🔒
Input Box - 3 🔒
Input Box - 4 🔒
MSG BOX
Introduction 🔒
MsgBox - 1 🔒
MsgBox - 2 🔒
MsgBox - 3 🔒
MsgBox - 4 🔒
ACTIVEX CONTROLS
MouseMove Event w. Appln Statusbar 🔒
USER FORMS
Introduction 🔒
User Form - Basics 🔒
Exercise - Part 1 of 4 🔒
Exercise - Part 2 of 4 🔒
Exercise - Part 3 of 4 🔒
Exercise - Part 4 of 4 🔒
Option Button - 1 🔒
Option Button - 2 🔒
Multi Page - Introduction 🔒
Multi Page - 1 🔒
Multi Page - 2 🔒
Multi Page - 3 🔒
Check Box 001 🔒
Combo Box - Method 1 🔒
Combo Box - Method 2 🔒
USER DEFINED FUNCTIONS
UDF Intro 001 🔒
UDF Example 1 - ScoreResult with IF END IF 🔒
UDF Example 2 - CellComments 🔒
UDF Samples - Series A 🔒
UDF Samples - Series B 🔒
MIS PROJECTS
Split Workbook 🔒
Protect - Unprotect Sheets 🔒
Index of Hyperlinks to all Sheets 🔒
Extract all Comments of a WBook to a new W Sheet 🔒
Project_Automate Comment Insertion and Extraction 🔒
Count Cells by Colors 🔒
Combine Wsheets 🔒
Review our Course
"Click Here" button to run a Macros 🔒
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock