You are NOT signed in as a student! Your progress will not be saved and you won't see milestones on your ZTM Passport.
Make sure you are logged into
Academy
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to Excel Automation: Excel Macros and VBA
Introduction
Introduction - Hello World (5:37)
A Note to Mac Users (2:26)
Exercise: Meet Your Classmates and Instructor
Course Resources
Cheatsheet
Introducing Excel Automation: Excel Macros and VBA
Opening Macro-Enabled Files (3:22)
Editing Macros (11:23)
Subroutine Structure (11:00)
Buttons and Shapes (7:17)
The Personal Workbook (10:02)
Exercise: Introducing Macros and VBA
Variables and User Input
Introducing Variables (4:22)
Using Variables in Expressions (11:49)
Option Explicit (4:26)
Gathering User Input (6:53)
Gathering User Input - A More Complex Example (7:38)
Exercise: Variables and User Input
Programming in VBA
Comments (5:12)
Error Handling With IF Statements (13:19)
Branching Logic With Else and ElseIf (11:59)
Formatting Code (4:39)
Naming Conventions (6:10)
Using Worksheet Functions in VBA (9:23)
User Defined Functions - A Simple Example (6:45)
User Defined Functions - A More Complex Example (7:48)
Converting UDFs to Add-Ins (5:54)
Objects, Properties and Methods (6:24)
Exercise: Programming in VBA
Where To Go From Here?
Review This Byte!
Exercise: Variables and User Input
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures