P
Philipp Schramek
Dear All
Following code is simple:
.....
For i=1 To 7
Worksheets("Sheet"&i).Range("A1").Value = i*2
Next i
.....
But if I want to do that with a TextBox how can I do that if I have
TextBox1 to TextBox7:
.....
For i=1 To 7
TextBox i .Value = i*2
Next i
.....
How do I program the line within the loop? I know, it would not work
like that.
Thanks Philipp
Following code is simple:
.....
For i=1 To 7
Worksheets("Sheet"&i).Range("A1").Value = i*2
Next i
.....
But if I want to do that with a TextBox how can I do that if I have
TextBox1 to TextBox7:
.....
For i=1 To 7
TextBox i .Value = i*2
Next i
.....
How do I program the line within the loop? I know, it would not work
like that.
Thanks Philipp