VBA Eval Dynamic Variables

[jaybee3]

So I've previously used Bash to do this. I was wondering if it's possible in VBA.

I have a variable (let's call it ii) that will change based on a function...etc
I then have another set of variables let's call then a1, a2, a3.

Is it possible to do something like evaulate(a & "ii")? to get the value held in a1, a2, a3..etc based on ii.?

 

[Firefly2012]

Hi

I don't believe this is directly possible in VBA.

 

[CharlesChuckieCharles]

a1="Bob", a2="harry", a3="June"

are they really an array of names

if so rather than
dim a1 as string
dim a2 as string
dim a3 as string

we would
dim a() as string

redim a(3) to size it to our needs

a(1)="bob"

a(2)="harry"

a(3)="June"


so if ii is an index say =2

a(ii) ="harry"
so your set of varibles could be a VBA array ()

But if you are asking "can you programatically build the name of a Variable" to get the content of that variable

I think NO not in VBA ... But I could be wrong!

 

[pgc01]

Hi

No.

The closest to what you want is:

- an array, and then you can use a(1), a(2), etc.

- a collection or a dictionary object. In that case you can use a1, a2, etc. as key

An array is the simplest solution.

 

[jaybee3]

OK cheers for the quick responses and suggestions guys. I'll try an array of arrays or collection.