#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Unload Me

Lee,

'Me' is a reserved word in VB that always refers to the instance of the
class in which it is used. So if it appears in the code for a UserForm1, it
refers to that instance of UserForm1. If it is used in Class1 it refers to
that instance of Class1. Similarly, if it is used in ThisWorkbook, it refers
to ThisWorkbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Lee" wrote in message
...
Hi! Friends:

I received a set of codes written by an unknown person. He
uses UNLOAD ME to unload an UserForm. I checked through
the module, nowhere he "defines" what "me" is. So, is ME a
reserve word in VBA to mean UserForm, or it is being
defined in somewhere else?

Appreciate your enlightenment.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove (not unload) a user installed Excel add-in ? bill h Excel Discussion (Misc queries) 1 March 1st 10 09:16 PM
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene LunaMoon Excel Discussion (Misc queries) 0 July 28th 08 11:03 PM
Form Unload Khai[_2_] Excel Programming 0 August 4th 03 09:28 PM
Time Format & Unload problem Rod Taylor Excel Programming 4 July 24th 03 11:31 PM
Unload from Memory Charles Williams Excel Programming 0 July 18th 03 08:42 AM


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"