Form not terminating

[foxguy]

When I run this sub, frmModalessForm.Terminate() is not executing. Why not?

Please Login or Register  to view this content.

If I "Unload oForm" then it executes, but why not when it's set to Nothing?

[MarvinP]

Hi foxguy,

Searching on VBA Excel Userform Show Hide Unload Terminate gave me:
http://support.microsoft.com/kb/829070

It claims "The Terminate event occurs after the UserForm is removed from memory".

I wonder if you can't terminate because it needs to still be in memroy by some other instruction?
http://msdn.microsoft.com/en-us/library/gg251819.aspx Using 2010?

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx got a RefEdit control on the form?

I'm clueless!!

[foxguy]

I guess that's what I'm asking.

Why doesn't "Set oForm = Nothing" remove the form from memory ?
Why do I have to use "Unload oForm" ?

[shg]

Setting it to Nothing releases the object variable, it doesn't affect the object.

[foxguy]

Does that mean that a form does not have any scope when I assign it to a variable? It would still exist in memory when the sub that creates it ends?