Naming of variables from array

Question

Is naming of variables with composition of text and another variables possible?

An example (not functional):

Components = "AA,BB,CC"
Values = "101,102,103"
ComponentsArr = Split(Components)
ValuesArr = Split(Values)
For i = 1 To UBound(ComponentsArr)
    Let "Var" & ComponentsArr(i) = ValuesArr(i)
Next i

No that's not possible in VBA; it doesn't have reflection. Actually not sure about reflection either... — D_Bester
– D_Bester, Commented Jan 6, 2016 at 10:02

Community · Accepted Answer · 2017-05-23 10:27:55Z

1

You might be able to use a dictionary to accomplish your purpose. You add key/value pairs to the dictionary. Then you can use the key to get the value.

Set a reference to MS Scripting runtime ('Microsoft Scripting Runtime')

Components = "AA,BB,CC"
Values = "101,102,103"
ComponentsArr = Split(Components, ",")
ValuesArr = Split(Values, ",")

Dim dict As New Scripting.Dictionary
For i = LBound(ComponentsArr) To UBound(ComponentsArr)
    Call dict.Add(ComponentsArr(i), ValuesArr(i))
Next i

If dict.Exists("AA") Then
    Debug.Print dict.Item("AA") 'prints 101
End If

See also: https://stackoverflow.com/a/915333/2559297

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Jan 6, 2016 at 10:10

D_Bester

5,9916 gold badges43 silver badges82 bronze badges

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

Comments

Kathara · Accepted Answer · 2016-01-19 11:56:14Z

1

It might be easier to do it like the following:

Components = Array("AA", "BB", "CC")
Values = Array("101", "102", "103")

Then you wouldn't need ComponentsArr and ValuesArr.

For i = LBound(Components) To UBound(Components)
    dict.Add(Components(i), Values(i))
Next i

edited Jan 19, 2016 at 11:56

answered Jan 7, 2016 at 9:43

Kathara

1,2901 gold badge12 silver badges37 bronze badges

1 Comment

D_Bester Over a year ago

Sure that works great. I took the first four lines as-is and focused on the dictionary aspect. Focusing on one idea can be an effective teaching tool.

Collectives™ on Stack Overflow

Naming of variables from array

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related