looping through userform controls

[switters_aka]

I am trying to loop through userform textbox controls to populate an array and want to use the loop variable in the code e.g.

for i=1 to 6
myarray(i,1)=userform2.mytextbox(i).value
myarray(i,2)=userform2.histextbox(i).value
myarray(i,3)=userform2.hertextbox(i).value
next i

This doesn't work though and I was wondering if anyone else had come across this issue before and found a solution. Thanks in advance for your help.

 

[baitmaster]

Why do you have "textbox(i)"? What are you trying to extract, to place into your array? the ith character of the text in "textbox"?

and how is your array defined?

 

[switters_aka]

just after hitting the send button I found the solution in another forum

userform2.controls("textboxname" & i).value

Thanks anyway for the response.