Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel equivalent of a "this" pointer...
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel equivalent of a "this" pointer...
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel equivalent of a "this" pointer...
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) "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel equivalent of a "this" pointer...
"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? Try Me. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel equivalent of a "this" pointer...
On Mar 16, 10:14*am, "Howard Kaikow" wrote:
"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? Try Me. Wow! Three responses in 15 minutes. Thanks! You guys rock. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard" | Excel Worksheet Functions | |||
Excel Equivalent of Access "Load" Event? | Excel Discussion (Misc queries) | |||
Is there an Excel 2003 equivalent to Word's "versions" function? | Excel Discussion (Misc queries) | |||
"MAXIF" Equivalent function in Excel | Excel Worksheet Functions | |||
what is the Excel macro command equivalent to "end up" | Excel Programming |