I hate to admit it, but I can't remember what "Me" means.
Anyone?
I hate to admit it, but I can't remember what "Me" means.
Anyone?
It is you!
Seriously, it is a refernce to the containing object, so in userform code, it refers to the userform, in ThisWorkbook code it refers to the workbook, and in a worksheet module code, it refers to that worksheet.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
actually, ME could refer to a Mechanical Engineer, a person with those initials, or the two you mentioned, i.e., the pronoun for self or the containing object in VB. For those "lucky" enough to be a mechanical engineer and have the initials ME, one is never quite sure what is going onOriginally Posted by xld
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
In programming (VBA)..it is the current container. The object whose code window is open...the IDE will/can see that as "ME" object.
Hmmmm . . . why would anyone use something that documents so poorly?? (Except to save some key strokes)
asingh, I've never understood how to pronounce a word that ends in "ingh". i don't suppose it's anything like "Ugh!" . . . or is it??
I use Me so that I can change the name of a userform without having to recode all the references.
In Class Modules, its almost manditory for some common things.
Also, I initial anything I approve ME .
pronounce it :
a + sing = Asingh..!
Posting Permissions
Reply With Quote
