Introduction
  • Course Overview
  • Macro Recording Basics
  • The VBA Editor
  • Macro Recorder and the VBA Editor
The Excel Object Library
  • VBA & The Object Library
  • Objects and Properties
  • Objects and Methods
  • More about Objects and Properties
  • Referencing a Range
  • Important Range Properties
  • The Worksheets Collection
  • The Workbooks Collection
  • Exploring the Object Library
  • The Excel Object Library
The VBA Language
  • Simple Input & Output
  • Variables & Data Types
  • Object Type Variables
  • VBA & Worksheet Functions
  • User-Defined Functions
  • Branching: IF...THEN
  • Branching: SELECT...CASE
  • Looping: DO...LOOP
  • Looping: FOR...NEXT
  • Looping: FOR...EACH
  • Variable Scope
  • Error Handling
  • Project 1 - The VBA Language
  • The VBA Language
Launching Macros: Events & Shortcuts
  • Macro Launching Shortcuts
  • Modifying the Ribbon
  • Workbook & Worksheet Events
  • Application Events
  • Project 2 - Event Handling
  • Launching Macros: Events & Shortcuts
Modifying the User Interface
  • Enhanced Message Box
  • ActiveX & The Worksheet (No Code)
  • ActiveX & The Worksheet (With Code)
  • Basic User Forms
  • Project 3 - User Forms & ActiveX
  • Modifying the User Interface
What's Next?
  • Reaching Beyond Excel