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!
Opening Macro-Enabled Files
Download