Excel Reference

Displaying a Custom Dialog Box

Direct Answer

Displaying a Custom Dialog Box
is part of the Excel VBA object model. This reference page documents its syntax, parameters, and typical usage.

Reference

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.

vb
Private Sub GetUserName()
UserForm1.Show
End Sub

!include[Support and feedback]

Reference: Excel object-model documentation • updated 06/08/2017
. Rebuilt for readability; see the original for complete parameter matrices.