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

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

Other Books You May Enjoy

If you enjoyed this book, you may be interested in these other books by Packt:

Learn Microsoft Office 2019

Linda Foulkes

ISBN: 978-1-83921-725-8

Use PowerPoint 2019 effectively to create engaging presentations
Gain working knowledge of Excel formulas and functions
Collaborate using Word 2019 tools, and create and format tables and professional documents
Organize emails, calendars, meetings, contacts, and tasks with Outlook 2019
Store information for reference, reporting, and analysis using Access 2019
Discover new functionalities such as Translator, Read Aloud, Scalable Vector Graphics (SVG), and data analysis tools that are useful for working professionals

Learn Power Query

Linda Foulkes, Warren Sparrow

ISBN: 978-1-83921-971-9