Programming in Excel 2013 and 2016

Like all previous versions of Excel, Excel 2016 comes with Visual Basic for Application (VBA) development tools, including a code editor. This allows you to create macros using logging, and in addition develop custom programs and functions by creating code in VBA. The VBA editor also allows you to create and use custom dialog boxes, add custom controls to the Excel workbook, and create new custom add-ins (Add In). The use of the VBA language significantly expands the capabilities of Excel 2016, both for its own use and for a wider range of users, e.g. for the needs of the corporate network.

This book assumes no prior knowledge of programming. Creating macros and VBA code in Excel 2016 is described from the very beginning.

The book contains the following topics: Creating macros using a record VBA basics and creating custom functions Working with cells, sheets and workbooks Using events Advanced programming techniques Working with charts and contingency tables Data analysis and control Working with files and external data Creating user dialogs Using graphical elements on a worksheet Creating custom controls and add-ons Communicating Excel with other MS Office applications