VBA Automation for Excel 2019 Cookbook | 4. Working with Procedures

VBA Automation for Excel 2019 Cookbook is available from:

This is the “Code in Action” video for chapter 4 of VBA Automation for Excel 2019 Cookbook by Mike Van Niekerk, published by Packt. It includes the following topics:

00:12 Creating Sub and Function procedures
01:11 Executing Sub procedures directly
01:28 Executing Sub procedures from the Macro dialogue box
01:40 Executing Sub procedures using buttons
02:29 Executing Sub procedures using a shortcut key
02:48 Executing Function procedures using a worksheet formula
03:07 Executing Function procedures calling from a Sub procedure

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: