Chapter 14. Creating Dialog Boxes and Customizing the Ribbon

UserForm Basics

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.

Get Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.