Table of contents
Collapse the table of content
Expand the table of content

Load Statement

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Loads an object but doesn't show it.



The object placeholder represents anobject expression that evaluates to an object in the Applies To list. Remarks When an object is loaded, it is placed in memory, but isn't visible. Use the Show method to make the object visible. Until an object is visible, a user can't interact with it. The object can be manipulated programmatically in its Initialize event procedure.


In the following example, UserForm2 is loaded during UserForm1's Initialize event. Subsequent clicking on UserForm2 reveals UserForm1.

' This is the Initialize event procedure for UserForm1 
Private Sub UserForm_Initialize() 
 Load UserForm2 
End Sub 
' This is the Click event of UserForm2 
Private Sub UserForm_Click() 
End Sub 

' This is the click event for UserForm1 
Private Sub UserForm_Click() 
End Sub
© 2018 Microsoft