View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PaulW PaulW is offline
external usenet poster
 
Posts: 130
Default Looping through TextBox's

Do Until x = 101
Sheets("Sheet1").Cells(n, x + 5) = TextBox(x).Value
x = x + 1
Loop

That's essentially what I want to do, take the values of Textboxes 1 to 100
and put them in columns F to whatever. How can I loop through the textboxes
without having to have a line for every box?