Getting Started
  • Introduction
  • About Me
  • Download Course Materials
  • Enable the Developer Tab
  • Excel File Types
  • Macro Security
  • The Macro Recorder
  • Record Macro to Change Worksheet Orientation
  • Absolute vs. Relative References I
  • Absolute vs. Relative References II
  • The Visual Basic Editor
  • VBA Basics
The Fundamentals of the Excel Object Model
  • Object-Oriented Programming in Real Life
  • Real Life Objects
  • Collection Objects in Real Life
  • Objects As Properties
  • The Excel Object Model
  • Access Object from Collection by Name
  • Default Properties
  • The Name Property on Workbook and Worksheet Objects
  • Object-Oriented Programming
The Visual Basic Editor
  • Visual Basic Editor Options
  • Create and Delete a Procedure
  • Procedures
  • The Immediate Window and Debug.Print Method
  • The MsgBox Method
  • Comments
  • Practice with Procedures
  • The Visual Basic Editor
Objects and Methods
  • Methods without Arguments
  • Methods without Arguments
  • Methods with Arguments
  • Methods with Arguments
  • Methods with Multiple Arguments
  • The Object Browser
  • Ways to Invoke A Procedure
  • The TypeName Method
  • Objects and Methods
Variables and Data Types
  • Syntax Tips
  • Variable Declarations and Assignments
  • Multiple Variable Declarations
  • The Option Explicit Setting
  • The Byte, Integer and Long Data Types
  • Numeric Data Types
  • Mathematical Operations
  • The Single and Double Data Types
  • The String Data Type
  • String and Double Data Types
  • The Boolean Data Type
  • The Date Data Type
  • The Variant Data Type
  • The Object Data Type
  • Default Values for Declared Variables
  • Variable Declarations
Procedures
  • Variable Scope
  • Call A Procedure from Another one
  • Procedures with Arguments
  • Procedure Scope (Public vs. Private)
  • The Exit Sub Keywords
  • Constants
  • Predefined Constants
  • Procedures
Object Deep Dive
  • The Application Object
  • The Application.DisplayAlerts Property
  • The Workbooks.Count and Worksheets.Count Properties
  • The Workbooks.Open Method and Workbook.Path Property
  • The Workbooks.Close Method
  • The Workbooks.Add Method
  • The Workbook.SaveAs and Workbook.Save Methods
  • The Workbook.Activate Method
  • The Workbook.Close Method
  • The Application, Workbooks and Workbook Objects
  • The Worksheets.Add Method
  • Add a New Worksheet to End of Current List of Worksheets
  • The Worksheet.Visible Property
  • The Worksheet.Copy Method
  • The Worksheet.Delete Method
  • The Worksheet.Move Method
Range References
  • The Range.Select Method
  • The Value vs. Text Properties
  • R1C1 Notation, Part I
  • R1C1 Notation, Part II
  • The Formula and FormulaR1C1 Properties
  • The Range.Offset Property
  • The Range.Resize Property
  • The Offset and Resize Properties
  • The Cells Property
  • The Range.CurrentRegion Property
  • The Range.End Property
  • The Range.Count and Range.CountLarge Properties
  • The Range.Row and Range.Column Properties
  • The Range.Rows and Range.Columns Properties