Chapter 13: Creating and Modifying Dialog Boxes

Dialog boxes are an integral part of every application in the Windows environment. The Office Suite is no exception. When it comes to Excel, a dialog box will pop up almost every time we interact with the application.

A dialog box should not be confused with a window. Windows can be resized, maximized, and minimized, while dialog boxes cannot be manipulated in that way. They appear in a standard size when information needs to be gathered or shared, after which they're closed.

This broad description of dialog boxes includes all forms and shapes of the item. For the purposes of this chapter, we will only work with message boxes, input boxes, and the open and close dialog boxes. On the other hand, ...

Get VBA Automation for Excel 2019 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.