Excel VBA & Macros Tutorials


Beginner module

Syllabus covered

Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)

Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

Excel VBA tutorial for beginners: Object Properties & Methods

Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)

Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)

Intermediate module

Syllabus covered

Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)

Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)

Excel VBA: Loop through cells inside the used range (For Each Collection Loop)

How to use the Message Box in Excel VBA (syntax you’ll need for msgbox)

Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook

Advanced module

Syllabus covered

Excel VBA FIND Function (& how to handle if value NOT found)

Excel ActiveX Combo Box to Select Worksheets with VBA

Link Page Header to Cell Value with Excel VBA

Excel VBA: Check If File or Folder Exists (DIR) – Open File or Create Folder

Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

Expert module

Syllabus covered

3 Methods to Unhide All Sheets in Excel (& how to hide)

Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)

Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA

How to SUM Cells by Color in Excel (Get it to update automatically)


Leave a Reply