Autoplay
Autocomplete
Previous Lesson
Complete and Continue
VBA Intermediate Training: Discover Excel Automation Secrets
Introduction
Introduction (2:16)
Course Exercise and Solution files
Course Support Files
VBA Language Details
Chapter 2 Preview (1:51)
Excel File Types (7:01)
Code Modules (6:53)
Detailed Memory Management (8:17)
Code Module Interactions (7:45)
The VBA Project Model (12:03)
Advanced Parameter Definitions (11:04)
Excel Events
What Are Events? (1:38)
Pre-Defined Events (6:53)
Event Parameters (6:45)
A Series Of Example Events (9:10)
Application Events (6:43)
Custom Objects
Chapter Overview + New Keyword (6:53)
Creating A Custom Type (5:43)
Create a New Class (8:58)
Defining a Class (8:57)
Practical Example of a Class (9:53)
Practice Test of a Class (7:49)
Special Class Variables and Components (9:08)
Initialization and Termination (9:03)
VBA Attributes and Usage (8:29)
Inheritance - Defining the Bookmarks Support Class (8:08)
Creating a Userform (10:26)
Designing a Userform (11:15)
Coding a Userform (9:52)
The Excel Interface
Modding the Excel Interface (11:39)
UI Interface Scope and Range (4:14)
UI Interface Control Options and Access (9:32)
External References and Office Interop
What are References? How do they work? (5:45)
Reference Object (6:26)
Office Libraries (3:46)
ADODB Library (6:33)
The Scripting Library (5:55)
Conclusion
Course Conclusion (1:45)
Course Quiz and Certificate of Completion
Code Modules
Complete and Continue