B
Brad Patterson
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?
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?