with Classes


You can add multiple values to a dictionary.
One way to do this is to create a class module called class_MultipleValues containing multiple fields


public myID As Integer 
Public myField1 As String
Public myField2 As Integer
Public myField3 As Boolean

Set oMyValues = New class_MultipleValues
oMyValues.myID = 1
oMyValues.myField1 = "text"
oMyValues.myField2 = 50
oMyValues.myField3 = False

oDict.Add(oMyValues.myID, oMyValues)



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext