MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Me command


Posted by Doug on June 01, 2001 4:59 AM

What exactly does the Me command do? Perform the specific operation on the active object? For example what exactly is "Unload Me" doing? is it saying active object unload? Thanks!


Posted by Dax on June 01, 2001 5:09 AM

Me returns a reference to the object that contains the code that is being executed. Me can be included in a class module (which includes workbook, worksheet and userform code modules) to refer to itself. Unload Me would be used in a userform to remove the userform from memory (as opposed to Me.Hide which does not, just makes it invisible).

HTH,
Dax.

Posted by Jim on June 01, 2001 5:15 AM

When an object is unloaded, it's removed from memory and all memory associated with the object is reclaimed.
Until it is placed in memory again using the Load
statement, a user can't interact with an object,and
the object can't be manipulated programmatically.

What exactly does the Me command do? Perform the specific operation on the active object? For example what exactly is "Unload Me" doing? is it saying active object unload? Thanks!