I updated the class from VB6 to VB.NET, which will be used in Excel through COM.
In VB6, I have a property defined in the MyScalars class as follows:
Public Property Get Item(vntIndexKey As Variant) As MyScalar Attribute Item.VB_UserMemId = 0 Set Item = mCol(vntIndexKey) ... End Property
This is similar to the fact that in Excel VBA I can access this property without specifying it (like the default property):
Dim oOut As Object Set oOut = MyScalars(Range("E10").Value)
Is there an equivalent attribute in VB.NET that does this? I tried the following, but it gives an error in VBA:
Default Public ReadOnly Property Item(ByVal vntIndexKey As String) As MyScalar Get If mCol.ContainsKey(vntIndexKey) Then Item = mCol.Item(vntIndexKey) End If ... End Property
ryrich
source share