MENU
Donate
=ARTICLES

Automation, Macros & VBA

10 tutorials written here on automation, macros & vba, plus 21 public automation, macros & vba videos from other channels, filed by level and subtopic.

All articles

Original tutorials

10
intermediateJul 30, 2026

Ablebits vs Kutools: which Excel add-in suite should you buy?

A practical comparison of Ablebits Ultimate Suite and Kutools for Excel to help you choose the right add-in for your work.

intermediateJul 30, 2026

Google Apps Script vs Excel VBA: the Sheets-side equivalent to VBA

How Google Apps Script and Excel VBA differ in language, execution environment, and capability, for anyone moving between Sheets and Excel automation.

intermediateJul 30, 2026

VBA snippets you'll reuse constantly

Ten short, copy-pasteable VBA snippets for the tasks that come up in almost every macro — last row, folder loops, error handling, and more.

beginnerJul 30, 2026

VBA editor basics: modules, Subs, and the Immediate window

A tour of the VBA editor for anyone past recorded macros — Project Explorer, modules, Sub vs Function, running code, and Option Explicit.

intermediateJul 30, 2026

VBA error handling and debugging

On Error Goto vs Resume Next, using breakpoints and Step Into to watch code run, and a clean pattern for handling errors without leaving a mess behind.

intermediateJul 30, 2026

VBA loops and conditions: For Each, Do While, and If/Select Case

How to repeat actions and branch logic in VBA, with worked examples looping over a range and renaming every worksheet in a workbook.

intermediateJul 30, 2026

VBA vs Power Automate: which one should automate your Excel task?

A practical comparison of VBA macros and Power Automate for automating Excel work — desktop scripting vs cloud workflow automation.

advancedJul 30, 2026

Workbook and worksheet events in VBA

How to run code automatically on Workbook_Open, Worksheet_Change, and Worksheet_SelectionChange, where that code has to live, and the infinite-loop gotcha that trips up nearly every beginner.

intermediateJul 30, 2026

Zapier vs Power Automate: which one should automate your Excel workflow?

Comparing Zapier and Microsoft Power Automate for Excel-adjacent automation — broad third-party app support versus native Microsoft 365 integration.

beginnerJul 24, 2026

Record your first macro in Excel (no coding required)

How to turn on the Developer tab, record a macro of repetitive steps, and run it again with one click — no VBA knowledge needed.

Video resources

Every automation, macros & vba video we have filed, published by other channels. All 21 are listed — nothing hidden behind a cap.

21
Excel VBA Online Course: Excel learning resourceMixedWiseOwlTutorialsJul 28, 2026How to Create & Use Excel Macros (Real world example): Excel learning resourceBeginnerLeila GharaniJul 28, 2026Excel VBA Introduction Part 1 - Getting Started in the VB Editor: Excel learning resourceBeginnerWiseOwlTutorialsJul 28, 2026Excel VBA Introduction Part 15 - Do Until and Do While Loops: Excel learning resourceIntermediateWiseOwlTutorialsJul 28, 2026Excel VBA Introduction Part 16 - For Next Loops: Excel learning resourceIntermediateWiseOwlTutorialsJul 28, 2026Excel VBA Introduction Part 20.1 - Event Procedures: Excel learning resourceIntermediateWiseOwlTutorialsJul 28, 2026Wise Owl Answers - How do I make a VBA event work in every workbook?: Excel learning resourceAdvancedWiseOwlTutorialsJul 28, 2026Excel 2019 VBA Beginner Tutorial: Excel learning resourceBeginnerLearn Skills DailyJul 28, 2026Excel Macros & VBA - Tutorial for Beginners: Excel learning resourceBeginnerKevin StratvertJul 28, 2026Learn Excel VBA to Automate Anything: Excel learning resourceMixedKenji ExplainsJul 28, 2026Excel VBA Macros - Beginner to PRO Masterclass with Code Samples: Excel learning resourceMixedChandooJul 28, 2026Automate Excel Without Becoming a Programmer: Excel learning resourceBeginnerMyOnlineTrainingHubJul 28, 2026SUPER EASY Excel Data Entry Form (NO VBA): Excel learning resourceAdvancedLeila GharaniJul 25, 2026How to Create Macros in Excel Tutorial: Excel learning resourceAdvancedKevin StratvertJul 25, 2026Excel 2021 VBA Full Course Tutorial (6+ Hours): Excel learning resourceAdvancedLearn Skills DailyJul 23, 2026Excel 2019 VBA Full Course Tutorial (7+ Hours): Excel learning resourceAdvancedLearn Skills DailyJul 22, 2026The Ultimate Excel Advanced Filters In VBA [Full Training Course]: Excel learning resourceAdvancedExcel For FreelancersJul 21, 2026Microsoft Excel VBA Tutorial: Excel learning resourceAdvancedProgrammingKnowledgeJul 20, 2026Unleash the Power of Excel with the Advanced Filter and Macros: Excel learning resourceAdvancedPaul O'MalleyJul 19, 2026Automate Emails in One Click with Excel VBA! Save Time with This Outlook Hack!: Excel learning resourceAdvancedJacob AutomationJul 18, 2026Excel 2021 VBA Full Course Tutorial (6+ Hours): Excel learning resourceAdvancedLearn Skills DailyJul 18, 2026

Sources we reference — not partners

26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.

Official documentation

Educators and channels

Course platforms

AI & data tools