looping through activex textbox to change value

[tp2468]

Hi All,

I know this topic has been posted many times before but even after extensive searching, I still can't something that works for me. I want to change the value of multiple activex textboxs. The data is stored in an array variable.

For i = 1 To 12
textnum(i) = Application.WorksheetFunction.Match(i, numrange, 0)
output(i) = Application.WorksheetFunction.Index(outputrange, textnum(i), 1)
Me.controls("Textbox" & i).Value = "" ' this line doesnt work
Next i

Will this method work? The loop works fine however Me.controls("Textbox" & i).Value does not work. What line of code will write to the textbox object from an array?

Many Thanks

Tom

 

[Norie]

Where are the textboxes located?

 

[tp2468]

Where are the textboxes located?

They are located on a worksheet

Thanks

Tom