Hi guys,
I assume it's possible to use array types in classes, but when I try and do the complier doesn't like my get property. I think this it's because I'm trying to pass it a variable. But I assume there is a way as otherwise it wouldn't be possible to ref an array with a get property statement.
Here is my code.
Private mavardteExDate() As Date
Public Property Let dteExDate(ByVal vData As Date)
ReDim Preserve mavardteExDate(UBound(mavardteExDate) + 1)
mavardteExDate(UBound(mavardteExDate) - 1) = vData
End Property
Public Property Get dteExDate(item As Integer) As Date
dteExDate = mavardteExDate(item)
End Property
Any advice would be good as I'm relatively new to classes in VBA, so looking to learn.
Thanks again,
T
Bookmarks