How to: Display Custom Dialog Boxes
To test your dialog box in the Visual Basic Editor, click Run Sub/UserForm on the Run menu in the Visual Basic Editor.
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