complex referals/variable names like string(cnt)

[xhonzi]

So,
I have a series of boxes names string0, string1, string2, etc.

I'm trying to assign values in a loop and I wanted to refer to them as string(cnt) and that doesn't work in VBA. Is there a proper syntax for this in VBA, or do I just need to go back to Perl?

for cnt = 0 to 10
  me.string(cnt).value = cnt
next

So, yeah this doesn't work. Am I missing something?

xhonzi

 

[TonyJollans]

You can't do this that way in VBA. You can define an array of strings:

[blue]Dim MyString(0 To 10) As String[/blue]

and then code with a variable for the array index:

[blue]For cnt = 0 To 10
    MyString(cnt) = cnt
Next cnt[/blue]

but you can't dynamically generate variable names.


Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[PHV]

Replace this:
me.string(cnt).value = cnt
with this:
Me.Controls("string" & cnt).Value = cnt

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TonyJollans]

Oops, sorry! Misread the question - you were not asking about simple variables.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website