VBA Automation for Excel 2019 Cookbook | 3. The VBA Object Model

VBA Automation Cookbook is available from:

This is the “Code in Action” video for chapter 3 of VBA Automation for Excel 2019 Cookbook by Mike Van Niekerk, published by Packt. It includes the following topics:
00:11 Understanding and identifying objects in VBA
00:39 Objects as a collection, and changing the attributes of the entire collection
02:00 Modifying object properties
02:58 Associating methods with objects
03:45 Using events to activate objects
05:00 Using the Object Browser in the VBA Editor

VBA Automation for Excel 2019 Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build your own custom programs and procedures to control applications in the Office suite.

Connect with Packt:

Video created by Belinda Loseby