What order does VBA look at userform controls?try something like

For i = 1 To 9
UserForm1.Controls("textbox" & i).Value = Range("a1").Offset(i, 0)
Next i

Lynn S
"Brad Patterson" wrote in message ...
I have the following code ...

For Each CT In userform1
If TypeOf CT Is MSForms.TextBox Then
CT.Text = ThisWorkbook.Worksheets("sheet1").Range("A1")(2, i).Value
i = i + 1
Else: End If
Next CT

Now, the tab order of my form is textbox1,2,3,4,5,6,7,8,9. However, the vba code produces the order textbox 1,2,6,7,3,4,5,8,9 ... This screws up my attempt at populating the textboxes with the values from columns of a table of data ...

How do I get it to go through them in the order I want?