0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

VBA Automation for Excel 2019 Cookbook

You're reading from VBA Automation for Excel 2019 Cookbook Solutions to automate routine tasks and increase productivity with Excel and other MS Office applications

Product type Paperback

Published in Sep 2020

Publisher Packt

ISBN-13 9781789610031

Length 362 pages

Edition 1st Edition

Languages

Visual Basic

Tools

Excel

Concepts

Management Software

Author (1):

Mike Van Niekerk

View More author details

Table of Contents (20) Chapters

Preface

1. Chapter 1: Getting Started with VBA

2. Chapter 2: Working with the VBA Editor FREE CHAPTER

3. Chapter 3: The VBA Object Model

4. Chapter 4: Working with Procedures

5. Chapter 5: Next Level Recording

6. Chapter 6: VBA Language Elements

7. Chapter 7: Working with Ranges

8. Chapter 8: Using Functions

9. Chapter 9: Implementing Program Flow

10. Chapter 10: Implementing Automation

11. Chapter 11: Handling Errors

12. Chapter 12: Debugging

13. Chapter 13: Creating and Modifying Dialog Boxes

14. Chapter 14: Creating UserForms

15. Chapter 15: UserForm Controls

16. Chapter 16: Creating Custom Functions

17. Chapter 17: Creating Word Documents with Excel VBA

18. Chapter 18: Working with PowerPoint in Excel VBA

19. Other Books You May Enjoy

Leave a review - let other readers know what you think

Technical requirements

This cookbook was written and designed to be used with MS Office 2019 and MS Office 365, installed on either Windows 8, 8.1, or 10.

In the case of MS Word, MS Excel, and MS PowerPoint, the VBA Editor can be activated by using the Alt + F11 keyboard shortcut. By pressing Alt + F11 a second time, you can switch between the Editor and the application you are working in.

Demonstration files can be downloaded from https://github.com/PacktPublishing/VBA-Automation-for-Excel-2019-Cookbook.

Please visit the following link to check out the CiA videos: https://bit.ly/3jQRvVk.

You have been reading a chapter from

VBA Automation for Excel 2019 Cookbook

Published in: Sep 2020

Publisher: Packt

ISBN-13: 9781789610031

© 2020 Packt Publishing Limited All Rights Reserved

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (1)

Mike Van Niekerk

Mike Van Niekerk

Mike Van Niekerk has consulted as an IT lecturer since 1995, mainly presenting project management and Microsoft Office end user application courses. With 39 years of applied experience in many industries, including language courses and the writing of manuals, he has acquired an exceptional ability to transfer knowledge. Being a Microsoft Office Specialist and Microsoft Certified Trainer, he is highly experienced in MS Word, Excel, PowerPoint, Access, MS Project, and VBA. He also works with, and trains on, Outlook, Publisher, and Visio. The training he has done includes all these applications on all levels, from beginner to advanced. He has written MS Office training manuals for several IT training companies in South Africa.

See other products by Mike Van Niekerk

Other recommended products

Related to this chapter

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26h 28m

Building Dashboards with Microsoft Dynamics GP 2016

Building Dashboards with Microsoft Dynamics GP 2016

The book shows you in detail how to build great-looking dashboards with Microsoft Dynamics GP. It will take you from creating amazing dashboards using various tools such as Excel 2016, Power BI to Jet Express. We will also cover core topics such as Business Analyzer, Microsoft SQL Reporting services reports, BI360, and more.

Mar 2017 11h 48m

Personalised recommendations for you

Based on your interests and search pattern

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m