MENU
Donate
=TOPIC

5 subtopics in this path

Automation, Macros & VBA

Macro recording, VBA basics, workbook events, loops, user forms, worksheet automation, and practical code safety.

=SUBTOPICS

What to learn inside Automation, Macros & VBA

Each item pairs the learning structure with curated public YouTube resources where available, so learners can move from outline to video practice quickly.

01Beginner

Record your first macro

Capture repeated actions, assign a shortcut, and understand the generated VBA.

YOUTUBE
02Intermediate

VBA editor basics

Navigate modules, procedures, variables, ranges, and the Immediate window.

YOUTUBE
03Intermediate

Loops and conditions

Use For Each, If statements, and range loops to automate repeated worksheet logic.

YOUTUBE
04Advanced

Workbook and worksheet events

Run code when users open files, change cells, or activate sheets.

YOUTUBE
video / Advanced

Wise Owl Answers - How do I make a VBA event work in every workbook?

WiseOwlTutorials

Open on YouTube (opens in a new tab)
WiseOwlTutorials

Loading preview…

05Intermediate

Macro safety and sharing

Understand trusted locations, signed macros, file formats, and safe distribution.

QUICK NOTES
  • A workbook with macros must be saved as .xlsm (or .xlsb), not .xlsx -- Excel strips macros from the plain .xlsx format on save.
  • File > Options > Trust Center > Trusted Locations lets macros in a specific folder run without a security prompt every time, instead of enabling macros file-by-file.
  • Never disable macro security globally to make a warning go away -- that removes the warning for every macro file opened afterward, not just your own trusted one.
=PREVIEW

Excel in action: Automation, Macros & VBA

Real Excel screenshots showing what this topic looks like in practice.

Running a macro from a button on the worksheet
VBA-powered data entry form in Excel
=VIDEOS

YouTube resources for Automation, Macros & VBA

playlist / Mixed

Excel VBA Online Course

WiseOwlTutorials

Structured VBA course playlist covering the main foundations needed for Excel macro automation.

Open on YouTube (opens in a new tab)
WiseOwlTutorials

Loading preview…

video / Beginner

How to Create & Use Excel Macros (Real world example)

Leila Gharani

Practical beginner-friendly macro recorder example that moves from recording to adapting the generated VBA.

Open on YouTube (opens in a new tab)
Leila Gharani

Loading preview…

video / Beginner

Excel VBA Introduction Part 1 - Getting Started in the VB Editor

WiseOwlTutorials

Focused starting point for navigating the Visual Basic Editor before writing macros.

Open on YouTube (opens in a new tab)
WiseOwlTutorials

Loading preview…

video / Intermediate

Excel VBA Introduction Part 15 - Do Until and Do While Loops

WiseOwlTutorials

Targeted lesson for repetition logic using Do Until and Do While loops.

Open on YouTube (opens in a new tab)
WiseOwlTutorials

Loading preview…

video / Intermediate

Excel VBA Introduction Part 16 - For Next Loops

WiseOwlTutorials

Clear follow-on video for For Next loops, one of the most common VBA automation patterns.

Open on YouTube (opens in a new tab)
WiseOwlTutorials

Loading preview…

video / Intermediate

Excel VBA Introduction Part 20.1 - Event Procedures

WiseOwlTutorials

Focused introduction to event-driven macros in Excel.

Open on YouTube (opens in a new tab)
WiseOwlTutorials

Loading preview…

video / Advanced

Wise Owl Answers - How do I make a VBA event work in every workbook?

WiseOwlTutorials

Advanced resource for handling application-level events across workbooks.

Open on YouTube (opens in a new tab)
WiseOwlTutorials

Loading preview…

video / Beginner

Excel 2019 VBA Beginner Tutorial

Learn Skills Daily

Useful for macro safety because it covers enabled content, trusted locations, and macro-enabled workbook behavior.

Open on YouTube (opens in a new tab)
Learn Skills Daily

Loading preview…

video / Beginner

Excel Macros & VBA - Tutorial for Beginners

Kevin Stratvert

Beginner-friendly walkthrough for recording, editing, and running Excel macros.

Open on YouTube (opens in a new tab)
Kevin Stratvert

Loading preview…

video / Mixed

Learn Excel VBA to Automate Anything

Kenji Explains

Practical overview of how VBA can automate repetitive Excel work.

Open on YouTube (opens in a new tab)
Kenji Explains

Loading preview…

video / Mixed

Excel VBA Macros - Beginner to PRO Masterclass with Code Samples

Chandoo

Broad masterclass that moves from macro basics into usable VBA code examples.

Open on YouTube (opens in a new tab)
Chandoo

Loading preview…

video / Beginner

Automate Excel Without Becoming a Programmer | Macros & VBA 101

MyOnlineTrainingHub

Introduces automation concepts for Excel users who are new to programming.

Open on YouTube (opens in a new tab)
MyOnlineTrainingHub

Loading preview…