show data into multiple textbox from filled listbox based on search textbox and highlight into listbox

[abdelfattah]

hello
i have data when show userform show all of data into list box i'm asking if is possible when i search data in textbox1 then show directly the data in multiple textbox and highlight by blue in listbox as my picture without i select this from listbox

 

[DanteAmor]

hi, dante it doesn't work the first row in list box asd12 it ' works for the rest data asd15,13...so on

check for whitespace in that cell

 

[abdelfattah]

actually i don't understand and i have another problem i found out it also occurs in the second row asd13

 

[DanteAmor]

Try this. works for everyone

Private Sub TextBox1_Change()
  Dim i As Long, j As Long
  
  With ListBox1
    For j = 2 To 10
      Controls("TextBox" & j) = ""
    Next
    .ListIndex = -1
    If TextBox1 = "" Then Exit Sub
    For i = 0 To .ListCount - 1
      If LCase(.List(i, 1)) = LCase(TextBox1) Then
        .Selected(i) = True
        For j = 2 To 10
          Controls("TextBox" & j) = .List(i, j - 2)
        Next
        Exit For
      End If
    Next
  End With
End Sub

 

[abdelfattah]

thanks dante you're legend the code is excellent what if i edit data in multiple textbox and update in listbox and worksheet

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.