Suche per Vba
16.05.2016 08:03:38
Michael
Gebe ich jetzt die Nummer 214 in die Textbox ein, wird mir die Nummer 2149 in der Listbox markiert.
Kann mir da jemand was zu sagen?
Gruß Michael
Private Sub TextBox4_Change()
Dim i As Integer, ii As Integer
Dim vntList, strTxt As String, arrSelected()
strTxt = LCase(TextBox4)
vntList = ListBox2.List
ReDim arrSelected(ListBox2.ListCount - 1)
For i = 0 To ListBox2.ListCount - 1
For ii = 0 To ListBox2.ColumnCount - 1
arrSelected(i) = InStr(LCase(vntList(i, ii)), strTxt) > 0
If arrSelected(i) Then Exit For
Next
Next
With ListBox2
For i = 0 To .ListCount - 1
.Selected(i) = arrSelected(i)
Next
End With
End Sub