How to Create a Dynamic Variable Name for an Array?

Question

I have "ComboBox1" with entries in it. Every time the user selects an entry, the following is triggered:

Private Sub ComboBox1_Change()
    call populate(ComboBox1.ListIndex)
End Sub

The function "populate" has the following:

Sub populate(index as integer)

    dim arr0, arr1, arr2 ...
        arr0 = Array(...)
        arr1 = Array(...)
        arr2 = Array(...)

    Do While x < Application.CountA("arr" + index)
        ...
    Loop

End Sub

I want to make "arr" + index dynamic so it calls the proper array based on the index recevied from the caller function. Can this be done?

Based on the answer below, what is the syntax to call an element within the dynamic name? Example, arr(index).x where x = 1 — Grendizer
– Grendizer, Commented Jul 25, 2015 at 22:44

Tim Williams · Accepted Answer · 2015-07-25 22:34:17Z

2

Sub populate(index as integer)

    dim arr(0 to 2)
        arr(0) = Array(...)
        arr(1) = Array(...)
        arr(2) = Array(...)

    Do While x < Application.CountA(arr(index))
        ...
    Loop

End Sub

answered Jul 25, 2015 at 22:34

Tim Williams

169k8 gold badges104 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Grendizer Over a year ago

How would you call an element? Example, arr(index).x ??

Collectives™ on Stack Overflow

How to Create a Dynamic Variable Name for an Array?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related