Mastering VBA for Microsoft Office 365, 2019th Edition

Chapter 14Creating Simple Custom Dialog Boxes

In this chapter, you'll start looking at Visual Basic for Applications’ tools for creating custom dialog boxes that interact with the user. The terms dialog box and form (or user form) are generally used interchangeably. Technically, a dialog box is a quite simple, small window, such as a message box or input box. Forms, generally, are larger windows featuring richer and more complex interaction with the user. These terms, though, are synonymous in common usage.

Dialog boxes and forms are among the most powerful and feature-packed elements of VBA. We will spend quite a bit of time in Chapters 14, “Creating Simple Custom Dialog Boxes,” and 15, “Creating Complex Forms,” exploring their uses as the ...