tags:

views:

34

answers:

2

I'm new to VBA, so this might be stupid. Is there an equivalent of 'this' pointer in VBA so that I can pass it to other module?

+3  A: 

Not for a module, no. A module doesn't have an instance, so there is no instance variable to pass. All the methods are static. If you are within a class instance, however, you can use Me.

Josh Einstein
Thanks, I think this is it.
DenMark
+3  A: 

Try "Me" for classes. Modules are global (like a static class) so have no instance concept.

Swanny
Thanks. "Me" is what I want.
DenMark