View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Philipp Schramek Philipp Schramek is offline
external usenet poster
 
Posts: 5
Default Variable TextBox

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