I have 'UserForm1' and Module1.
In UserForm1:

Private Sub UserForm_Initialize()
Debug.Print "Initialized"
End Sub

Private Sub UserForm_Terminate()
Debug.Print "Terminated"
End Sub

In Module1:

Sub Main()

Debug.Print "Set UserForm1 to nothing"
Set UserForm1 = Nothing

Debug.Print

Debug.Print "Unload UserForm1"
Unload UserForm1

End Sub

After running 'Main', the result is:
-------------------------
Set UserForm1 to nothing

Unload UserForm1
Initialized
Terminated
-------------------------
This means Unload statement creates a new instance of UserForm before
destroying it.
What makes the difference between Set and Unload?
Are there any other differences between those?

setting an object to nothing returns the memory....

--
Wendell A. Clark, BS
-------------------------------------

CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. If you are not the intended recipient,
please notify us by reply e-mail. You are hereby notified that you have
received this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is prohibited.
If you have received this communication in error, please destroy all copies
of this communication and any attachments. Contact the sender if it
continues.


"Zoo" wrote in message
...
I have 'UserForm1' and Module1.
In UserForm1:

Private Sub UserForm_Initialize()
Debug.Print "Initialized"
End Sub

Private Sub UserForm_Terminate()
Debug.Print "Terminated"
End Sub

In Module1:

Sub Main()

Debug.Print "Set UserForm1 to nothing"
Set UserForm1 = Nothing

Debug.Print

Debug.Print "Unload UserForm1"
Unload UserForm1

End Sub

After running 'Main', the result is:
-------------------------
Set UserForm1 to nothing

Unload UserForm1
Initialized
Terminated
-------------------------
This means Unload statement creates a new instance of UserForm before
destroying it.
What makes the difference between Set and Unload?
Are there any other differences between those?