Excel 2021 VBA-Programmierung Makro-Programmierung für Microsoft Excel 2021, 2019, 2016, 2013 und

Excel 2021 VBA - Programming - The Perfect Introduction

If you want to customize Excel to meet your individual needs, then work with the VBA development environment. In this book, you will learn the basics of VBA for daily work simplification and Excel automation. You will program macros, learn about variables, arrays, objects, and events, and work with UserForms. The book is well-structured didactically, with many exercises and practical examples.

Highlights:

• Perfect introduction to VBA without prior knowledge
• Practical examples with illustrative exercises
• All macros available for download

Content includes:

• The options in the VBA editor
• Objects, properties, and methods
• Variables and constants
• The macro recorder
• Custom functions
• Form controls in the worksheet
• Macros for Power Query and Power Pivot
• Programming with tables
• Dialog programming with UserForms
• VBA in the worksheet
• Drives, folders, and files
• Events
• VBA and Microsoft Office
• Business Intelligence: Macros for Power Query and Power Pivot
• Programming the ribbon and toolbar
• VBA macros in the ribbon
• Certifying macros
• Know-how from A to Z

The Author
Ignatz Schels is a computer scientist, programmer, and expert in Microsoft Windows and Microsoft Office. He has been writing for Markt+Technik for over 30 years, and many of his books are bestsellers.