| 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) |
|