See Also Example
Unloads a form
Syntax
Unload object
Remarks
The argument object is the form or control array element to unload.
Unloading a form or control may be necessary or expedient in some cases where the memory used is needed for something else or when you need to reset properties to their original value.
Before a form is unloaded, the Query_Unload event occurs, followed by the Form_Unload event. Setting the Cancel argument to True in either of these events keeps the form from being unloaded. For MDI forms, the MDI form Query_Unload event occurs, followed by the Query_Unload event and Form_Unload event for each MDI child form, and finally the MDI form Form_Unload event
When a form is unloaded, all controls placed on the form at run time Controls placed on the form at design time remain intact, although any run-time changes to those controls and their properties are lost when the form is reloaded. All changes to form properties are also lost. Note that when a form is unloaded, only the displayed component is unloaded. The code associated with the form module remains in memory.
Only control array elements added to a form at run-time can be unloaded with the Unload statement. The properties of unloaded controls are reinitialized when the controls are reloaded.
Hide Method
Load Statement
QueryUnload Event
Show Method
The example uses the Unload statement to unload a form. To try this example, paste the code into the Declarations section of a form named Form1. Then press F5 and click the form.
Sub Form_Click ()
Dim Answer, Msg ' Declare variables
Unload Form1 ' Unload form.
Msg = "Form1 has been unloaded. Choose Yes to load and "
Msg = Msg & "display the form. Choose No to load the form "
Msg = Msg & "and leave it invisible."
Answer = MsgBox(Msg, 4) ' Get user response.
If Answer = 6 Then ' Evaluate answer.
Show ' If Yes, show form.
Else
Load Form1 ' If No, just load it.
Msg = "Form1 is now loaded. Choose OK to display it."
MsgBox Msg ' Display message.
Show ' Show form.
End If
End Sub