Part IV ENHANCING THE USER EXPERIENCE

Excel 2016 comes with the Ribbon interface enhanced with additional tools that enable you to create superb-looking worksheets.

In this part of the book, you learn how to create desired interface elements for your users via Ribbon customizations and how to create dialog boxes and custom forms. You will also learn how to format spreadsheets with VBA and control Excel with event-driven programming.

Chapter 15

Event-Driven Programming

Chapter 16

Using Dialog Boxes

Chapter 17

Creating Custom Forms

Chapter 18

Formatting Worksheets with VBA

Chapter 19

Context Menu Programming and Ribbon Customizations

Chapter 20

Printing and Sending Email from Excel