Occurs after an object is loaded, but before it's shown.
Private Sub object_Initialize( )
The object placeholder represents an object expression that evaluates to an object in the Applies To list.
The following example assumes two UserForms in a program. In UserForm1's Initialize event, UserForm2 is loaded and shown. When the user clicks UserForm2, it is hidden and UserForm1 appears. When UserForm1 is clicked, UserForm2 is shown again.
' This is the Initialize event procedure for UserForm1 Private Sub UserForm_Initialize() Load UserForm2 UserForm2.Show End Sub ' This is the Click event of UserForm2 Private Sub UserForm_Click() UserForm2.Hide End Sub ' This is the click event for UserForm1 Private Sub UserForm_Click() UserForm2.Show End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.