Mathieu Guindon's user avatar
Mathieu Guindon's user avatar
Mathieu Guindon's user avatar
Mathieu Guindon
  • Member for 9 years, 6 months
  • Last seen this week
Stats
74,704
reputation
4.0m
reached
869
answers
157
questions
Loading…
About

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 (retired) on Code Review Stack Exchange, 2015-2021
Microsoft MVP (Office Apps & Services), 2018-2022

Rubberduck
rubberduckvba.com | twitter | github | wordpress

17
gold badges
185
silver badges
457
bronze badges
2,988
Score
559
Posts
54
Posts %
1,293
Score
282
Posts
27
Posts %
763
Score
155
Posts
15
Posts %
538
Score
56
Posts
5
Posts %
416
Score
79
Posts
8
Posts %
407
Score
72
Posts
7
Posts %
Top posts
View all questions and answers
question
125
Aug 29, 2014
answer
61
Apr 27, 2016
question
50
Oct 13, 2013
question
44
Dec 8, 2014
answer
42
Aug 15, 2015
question
40
Oct 15, 2014