Creating a custom dialog box - first create a user form
>
Creating a User Form in Microsoft Excel
Forms are objects in Excel that help us to enter data quickly and easily. To create a custom dialog box in Excel, you must create a UserForm. To create a UserForm, click UserForm on the Insert menu in the Visual Basic Editor.The training video describes how this is a straightforward one click step.
Use the Properties window to change the name, behavior, and appearance of the form. For example, to change the caption on a form, set the Caption property.
