Displaying a Custom Dialog Box

To test your dialog box in the Visual Basic Editor, click Run Sub/UserForm on the Run menu.

To display a dialog box from Visual Basic, use the Show method. The following example displays the dialog box named UserForm1.

  Private Sub GetUserName()
    UserForm1.Show
End Sub

Note
Use the Unload method in an event procedure, such as the Click event procedure for a command button, to close a dialog box.