Chapter 14. Creating Dialog Boxes and Customizing the Ribbon
Every Windows application uses dialog boxes to gather information from the user, and Excel is no exception. For example, you can use the Open dialog box in Excel to select a file to open. VBA has two ready-made dialog boxes, MsgBox and InputBox, that you can use with your code. In addition, you can create your own custom dialog boxes. See Chapter 7 for more information on the MsgBox and InputBox dialog boxes.