Hi
I have about 24 textboxes when I select the item from listbox should populate from textbox 1 to textbox24 , but it populates staring from textbox 3,
the textbox1,2 is empty !!! what's the mistake?
I have about 24 textboxes when I select the item from listbox should populate from textbox 1 to textbox24 , but it populates staring from textbox 3,
the textbox1,2 is empty !!! what's the mistake?
VBA Code:
Private Sub ListBox1_Click()
For i = 0 To ListBox1.ListCount
If ListBox1.Selected(i) = True Then
For j = 1 To 24
Controls("TextBox" & j).Text = Cells(ListBox1.List(i, 1), j)
Next j
End If
Next i
End Sub