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)




"Dave" wrote in message
...
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