Simple Question

[Tridiro]

In VBA, what does "me" mean ?


example: me.textbox1.hide

I cant find it in the object browser.

 

[Misca]

"Me" refers to the form the textbox is found on. Or actually the form (/report in Access) running the sub or function you are in.

 

[xenou]

It's self-referential, in regard to the containing class and its properties, methods or child objects. Hence, determined by context. Most frequently in Excel VBA you see it in userforms (referring to the userform containing the code) or to worksheets (referring to the worksheet containing the code).

But you *could* also use it in a custom class to refer to a class method or property.

That's my best on the subject - once you get used to it you'll find it handy.

ξ

 

[dcctraining]

It's self-referential, in regard to the containing class and its properties, methods or child objects. Hence, determined by context. Most frequently in Excel VBA you see it in userforms (referring to the userform containing the code) or to worksheets (referring to the worksheet containing the code).

But you *could* also use it in a custom class to refer to a class method or property.


ξ

Thanks a lot for your helpful information. Keep up the good work.