[AttributesInVBA] - Overloaded default procedure?

[elie-g]

Is it possible to create an overloaded default procedure?

So you could do something like this:
------------ Class ------------

'...
Public Function DefaultProc() As Something
	Attribute '...
	'...
End Function

Public Function DefaultProc(ByVal myNumber As Integer) As Something
	Attribute '... ??
	'...
End Function

Public Function DefaultProc(ByVal myString As String) As Something
	Attribute '... ??
	'...
End Function
'...

------------ Main ------------

Dim Instance As New MyClass
Debug.Print Instance
Debug.Print Instance("Joe")
Debug.Print Instance(1)

[Vitosh]

@DrunkenPoney - give it a try and write a few tests. If it works, I will add it to the project.

[elie-g]

@Vitosh I tried it but I couldn't find any way to overload the default function/procedure. Though, I'm not an expert in VBA and there might be a way I don't know but a simple overload with the same procedure name but with different parameters does not work. I also tried to set the same VB_UserMemId attribute but it didn't work either.

[Vitosh]

@DrunkenPoney - Joel Spolsky has some ideas here:
https://stackoverflow.com/questions/64436/function-overloading-and-udf-in-excel-vba
(The guy literally put VBA in Excel, so he is a good source :)