VBA programming in Excel. Self -appropriate. Komolova N.V., Yakovleva E.S.

The book is devoted to the possibilities of programming in the Visual Basic for Applications (VBA) in the modern Microsoft Office Excel. Information about Power services for work, new products Excel 2021, including dynamic arrays and functions for work, take information. Theoretical information about programming, elements of the Excel object model, launching and debugging macros are given. The issues of automation of the working sheet using the Excel control elements are considered.

Descriptions of the creation of macros, user functions and forms in the Visual Basic editor. Methods of interaction using VBA with other Microsoft Office package programs are given. To consolidate the material, examples of user applications in the form of listing programs with analysis and explanatory comments are considered.

The applications contain glossaries with the main terms of VBA and the editor of Visual Basic VBE.

Workbooks with macros support for each chapter are posted on the publishing house.

for A wide circle of users.