72,302
reputation
3
86
229

Mathieu Guindon
Moderator

About Me

Me is a reserved name (you can't have a variable by that name) that refers to something that can only exist at run-time in a procedure's scope: the current object. Under the hood, when you make a member call to DoSomething against a Class1 object, the call goes essentially like this:

Set obj = New Class1
Class1.DoSomething obj

This means DoSomething looks like this in VBA:

Public Sub DoSomething()
End Sub

But VBA sees it like this:

Public Sub DoSomething(ByVal Me As Class1)
End Sub

That makes Me an implicit locally-scoped ByVal parameter of type Class1, and inside the DoSomething scope it holds a reference to whatever object the caller is currently using.


Moderator on Code Review Stack Exchange, 2015-2018, 2019-
Microsoft MVP (Office Apps & Services), 2018-

Rubberduck
rubberduckvba.com | twitter | github | wordpress

256
answers
87
questions
~112k
people reached

Top tags (98)

Score 2,310
Posts 307
Posts % 90
Score 278
Posts 22
Score 248
Posts 29
Score 235
Posts 35
Score 227
Posts 61
Score 181
Posts 28

Top posts (343)

View all questions and answers

Badges (318)

Gold

3

Rarest

Silver

86

Rarest

Bronze

229

Rarest