Userform TextBox Loop (retrieve data from sheet)

[ricafonyat]

I am trying to populate 10 TextBoxes in a Userform with values from Cells located in Sheet1 - Cells in Collumn E and starting in Row 4.
The below For Next Loop is not working correctly, because All textboxes are showing the same value ( Value from sheet1 cell E13)

   Dim row As Long
   For counter = 1 To 10
      For row = 4 To 9
         Userform1.Controls("TextBox" & counter).Value = Sheet1.Cells(row, "E")
      Next row
   Next counter

Any help would be appreciated

 

[Fluff]

How about

Dim Counter As Long
For Counter = 1 To 10
   UserForm1.Controls("TextBox" & Counter).Value = Sheet1.Cells(Counter + 3, 5).Value
Next Counter

 

[ricafonyat]

Tks a lot!

It works nicely!

 

[Fluff]

You're welcome & thanks for the feedback.