Excel Automation: Learn VBA & Macros From Scratch!

Explore what VBA and macros are, learn the difference between them, and write your first macro in the VBA window while mastering Excel and workbook objects, functions, properties, and methods.

Discover how Excel's front end interfaces with a VBA back end, and how macros trigger button clicks to execute code in Excel.

Discover how object oriented programming language uses objects and their properties to communicate with the system in VBA, enabling outsourcing of work beyond plain language.

Learn object referencing in VBA for Excel by using names such as workbooks, sheets, and range, or by index positions, including referencing cells like B5 by row and column.

Explore the VBA window and developer tab; learn to create and run macros with sub and end sub, including running via play or F5.

Explore how objects, functions, properties, and methods form the four pillars that define every action in Excel, with functions on cells, properties on objects, and methods on sheet objects.

Learn how objects and methods connect in VBA, using dot notation to call a sheet delete method. Distinguish methods from properties with a hands-on Excel macro.

Use variables to make VBA macros dynamic and differentiate them from constants that stay fixed. Define variables before use and store numbers or text in quotes to ensure reusable code.

Learn how to use conditional loops in VBA with do until and do while, start from 1, define the ending condition at 10, and manually increment n to repeat actions.

Handle Excel VBA macro errors using on error resume next to ignore them or on error goto to take action. Guard against runtime errors like subscript out of range.

Master the core macro vocabulary for Excel as you learn how keywords guide writing macros, enabling tasks like coloring a cell, sorting or filtering data, and adjusting sheet settings.

Combine writing and recording to create advanced macros, explain when to write versus record, and cover conditional statements and sheet or cell references for driving actions.

Learn to design VBA macros from an end-user perspective, focusing on event-driven execution—time, button, keystroke, or situation—and prepare for subroutines, private subroutines, and the functions routine.

Reveal how excel macros use public subroutines to give end users control, by binding macros to events, buttons, or keyboard shortcuts and clarifying who defines what the macro does.

Learn to create a custom keystroke in Excel by mapping the home key to a macro with VBA, demonstrating the setup and its workbook-only persistence.

Explore private subroutines and system-created macros in Excel automation, using predefined events to trigger macros. Learn where to find macros and how to assign tasks, choosing appropriate end user controls.

Learn how to auto-run a macro on workbook open using VBA, display a message box, and navigate workbook events and private subs within the VBA editor.

Learn to build a dynamic VBA function in Excel that uses cell references as input. Multiply values by 100 and understand how Excel and VBA interact for reusable functions.

Learn to create an application-specific macro in Excel to count the number of sheets in the active workbook, accessible from any workbook via the quick access toolbar.