What are User Forms in MS Excel?
Create User Form in Excel – Step 1 of 3
How to create a user form in Excel VBA? 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 Excel 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.
Create an Excel UserForm