Mega Code Archive
To remove the Userform from the computers memory, you must use the Unload statement; otherwise, the Userform is only hidden
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Unload Me 'Removes Userform named frmStats from memory.
End Sub