Operator Overloading in VBA

Question

I have noticed that, when I create a custom collection class (as explained in this blog) , the operator "()" becomes automatically available so that it is a synonym to the Item method.

Are there other forms of operator overloading, implicit or otherwise, available in VBA? And where are those behaviors documented?

score 3 · Accepted Answer · edited May 23 '17 at 10:32

3

This is not operator overloading, this is marking a property as the default property of an object.

This is a COM feature, and it is merely supported by VB.

When an object that has a default property is used in a non-reference context (without Set), the value of the default property will be automatically used instead of the object pointer.

See here for more information (also follow the other links from there).

edited May 23 '17 at 10:32

Community

1
1

answered Dec 23 '13 at 07:25

GSerg

76,472
17
159
346

FYI - To implement a default property you have to export the .cls file, edit it with Notepad and re-import it in your project. – John Alexiou Dec 23 '13 at 15:53
@ja72 Yes, this is what is suggested in the article linked by the OP. – GSerg Dec 23 '13 at 18:08

Operator Overloading in VBA

1 Answers1

Linked