Function Array

[verluc]

why this function doesn't work?

Controls(Array("T1", "T2", "T3")).Value="yy"

Many thanks

 

[Norie]

Why should it work?

 

[verluc]

With the function array:
Sheets(Array("sheet1", "sheet2", "sheet3")).Select
I can select in one time the sheets
In a userform I want to do the same with 3 tests, I called test1,test2,test3
Controls(Array("T1", "T2", "T3")).Select

Here I get an error : typen are not the same.
Why?

 

[Norie]

Worksheets and controls on a userform are completely different objects.

For I = 1 To 3
     Me.Controls("T" & I) = "yy"
Next I