Excel equivalent of a "this" pointer...

[Dave]

I'm sure this has been posted before, but searching the group for
instances of "this" has proven to be a daunting task. Do any of
you know if there is the equivalent of a "this" pointer in a VBA
class? That is, a reference to the current instance of a class?

Thanks!
Dave

 

[Chip Pearson]

Use the "Me" reference. E.g.,

Me.Name = "ABC"


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Bob Phillips]

Me refers to the worksheet class, the userform class, the ThisWorkbook
class, so may be what you want.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Howard Kaikow]

I'm sure this has been posted before, but searching the group for
instances of "this" has proven to be a daunting task. Do any of
you know if there is the equivalent of a "this" pointer in a VBA
class? That is, a reference to the current instance of a class?

Try Me.

 

[Dave]

Try Me.

Wow! Three responses in 15 minutes. Thanks! You guys rock.