Setting a collection property for a object in VBA

Question

I am having a class which has Collection as a property,

Bond Class

Private pBondiSIN As String
Private pBroker As Collection

''''''''''''''''''''''
' BondiSIN property
''''''''''''''''''''''
Public Property Get BondiSIN() As String
    BondiSIN = pBondiSIN
End Property
Public Property Let BondiSIN(Value As String)
    pBondiSIN = Value
End Property

''''''''''''''''''''''
' Broker property
''''''''''''''''''''''
Public Property Get Broker() As Collection
    Broker = pBroker
End Property
Public Property Let Broker(Value As Collection)
    pBroker = Value
End Property

And I call it this way:

Set tempBond = New Bond
tempBond.Broker = New Collection  => Gives me a error as Wrong number of Arguments or Invalid property assignment

Not sure how to solve this error. Need some help on this.

Use the `Set` keyword for complex objects like Collections – Sep 10 '15 at 09:27 — , Sep 10 '15 at 09:27

score 5 · Accepted Answer · edited May 23 '17 at 11:52

5

Get familiar with the Set keyword

Public Property Set Broker(Value As Collection)
    Set pBroker = Value
End Property

and

Set tempBond.Broker = New Collection

edited May 23 '17 at 11:52

Community

1
1

answered Sep 10 '15 at 09:35

when to use let and when to use set? – lakshmen Sep 10 '15 at 09:47
1

[have you already searched for an answer?](http://stackoverflow.com/search?q=%5Bvba%5D+set+let) – Sep 10 '15 at 10:50

Setting a collection property for a object in VBA

1 Answers1