Loop issues for textboxs with variables

[Blckbx]

I have 27 textboxes and am wishing to cycle through them using a do... loop.
this code doesn't work:

N = 1
Do
textbox(N).text = someStringArray(N-1)
N = N + 1
loop until N = 27

brings up a compile error: sub or function not defined

it doesn't like &, +, () and []. nothing works.

any suggestions?

cheers. Black Box

[MMcCarthy]

N = 1
Do until N = 27
control("textbox" & N).text = someStringArray(N-1)
N = N + 1
loop

I have 27 textboxes and am wishing to cycle through them using a do... loop.

this code doesn't work:

N = 1
Do
textbox(N).text = someStringArray(N-1)
N = N + 1
loop until N = 27

brings up a compile error: sub or function not defined

it doesn't like &, +, () and []. nothing works.

any suggestions?

cheers. Black Box

[Killer42]

N = 1
Do until N = 27
control("textbox" & N).text = someStringArray(N-1)
N = N + 1
loop

I'd just like to point out, the original code might work if the text boxes are a control array. Which I believe is generally considered more efficient anyway.

[MMcCarthy]

You're probably right.

I'd just like to point out, the original code might work if the text boxes are a control array. Which I believe is generally considered more efficient anyway.