This is the code repository for VBA Automation for Excel 2019 Cookbook, published by Packt.
Solutions to automate routine tasks and increase productivity with Excel and other MS Office applications
Visual Basic for Applications (VBA) is a programming language developed and owned by Microsoft to automate routine computing tasks in MS Office applications. This book provides comprehensive coverage of VBA automation using a variety of practice problems to help you automate daily tasks and extend the capabilities of Excel and other Office applications.
This book covers the following exciting features: Understand the VBA programming language’s role in the context of the MS Office suite Discover various aspects of VBA programming such as its terminology, syntax, procedures, functions, and forms Investigate the elements, features, and characteristics of the VBA Editor to write and edit custom scripts Automate Excel sheets with the help of ranges Explore error handling and debugging techniques to catch bugs in your programs Create and use custom dialogue boxes to collect data from users Customize and extend Office apps such as Excel, PowerPoint, and Word
If you feel this book is for you, get your copy today!
All of the code is organized into folders. For example, Chapter02.
The code will look like the following:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "This file cannot be closed"
Cancel = True
End Sub
Following is what you need for this book: This book is for experienced Excel users, business analysts, finance professionals, and business users looking to boost their productivity by learning VBA programming to automate repetitive, tedious, or complex tasks. No prior programming experience is required to get started with this book.
With the following software and hardware list you can run all code files present in the book (Chapter 1-18).
No | Software required | OS required |
---|---|---|
1 | Excel 2019/365 | Windows |
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.
Click on the following link to see the Code in Action: https://bit.ly/3jQRvVk
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.