[RESOLVED] Using UBound elements from existing array to create new array?

[Elroy]

It sounds like given some array of existing data, they want to create a parallel array of the same size and store some additional data related to each element of the first array.

Hmmm, ok, if that's the case, yes an array of some UDT structure is what comes to mind for me. Swambast, with a UDT, you could mix different data types in each array element, which is precisely what UDTs are for.

Option Explicit
'
Private Type MyUdtType
    i As Long
    s As String
End Type


Private Sub Form_Load()
    Dim MyUdtArray() As MyUdtType

    ReDim MyUdtArray(0 To 3)

    MyUdtArray(0).i = 123:      MyUdtArray(0).s = "asdf"
    MyUdtArray(1).i = 456:      MyUdtArray(1).s = "qwer"
    MyUdtArray(2).i = 789:      MyUdtArray(2).s = "zxcv"
    MyUdtArray(3).i = 765:      MyUdtArray(3).s = "ghjk"

    ' And so on.


End Sub

I suppose parallel arrays would also work, but then you'd have to make sure you keep the dimensions in-sync.

Good Luck,
Elroy