Programming in Excel 2019

Excel 2019 (like all previous versions) allows you to work with Visual Basic for Application (VBA). The Excel installation includes a code editor that allows you to create macros using a record, but most importantly it also allows you to develop your own programs and functions using VBA code.

You can also create and launch custom dialogs, add additional controls to Excel workbooks, and create new add-ins (Add In). The use of VBA in Excel 2019 significantly expands the capabilities of previous versions, both for personal use and for other users, for example, via a corporate network.

The book assumes no prior knowledge of programming, creating macros and VBA code in Excel 2019 is explained from the very basics.