Programming in VBA in Excel. Self-tutorial

The book is dedicated to the possibilities of programming in Visual Basic for Applications (VBA) in the modern office application Microsoft Office Excel. It provides information about Power services for working with data, new features of Excel 2021, including dynamic... arrays and functions for working with them. Theoretical information about programming, elements of the Excel object model, running and debugging macros is provided. Questions of automating the worksheet using Excel controls are considered. Techniques for creating macros, user functions, and forms in the Visual Basic editor are described. Methods of interaction using VBA with other Microsoft Office applications are presented. To reinforce the material, examples of user applications in the form of program listings with analysis and explanatory comments are discussed. The appendices contain glossaries with the main terms of VBA and the Visual Basic Editor (VBE). Files of macro-enabled workbooks for each chapter are available on the publisher's website. For a wide range of users.