Displaying a User Form

You can display a UserForm by using the UserForm's Show method in a VBA procedure.

The macro that displays the dialog box must be in a VBA module — not in the Code window for the UserForm.

The following procedure displays the dialog box named UserForm1:

Sub ShowDialog()

UserForml.Show ' Other statements can go here End Sub

When Excel displays the dialog box, the macro halts until the user closes the dialog box. Then VBA executes any remaining statements in the procedure. Most of the time, you won't have any more code in the procedure. As you later see, you can put your macro code in the Code window for the UserForm.

0 0

Post a comment