Excel VBA: Can I refer to a textbox as a variable?

Quick question about textboxes and For-Next loops.

I have a series of textboxes in a userform, used chronologically (ie, textbox1, textbox2, ... textboxN)

Lets say I have a For Next loop, 1 to N, how can I refer to the textboxes? I have tried (and failed) to use code like below:

For i = 1 to N
     Range("A" & i) = textbox & i
Next i

I am 99% sure I have done something like this before, and I just cannot remember how.

Hello BigBas,

Like this...

For i = 1 to N
     Range("A" & i) = Controls("TextBox" & i).Value
Next i

Sincerely,
Leith Ross

^ Thank you. Exactly what I needed.

I am trying to do something similar, but it isn't working as shown above

for i = 1 to 6

controls("form.textbox" & i).value = formatcurrency(0, 2)

Next

I get the "sub or function not defined" error.