|
关键字改列简单,改一个字就行,输入别的列内容就不好说了,输错了没有显示即可:
Private Sub TextBox1_Change()
Dim ITM, arr, i%, j%
Me.ListView1.ListItems.Clear
With Sheets("资料")
arr = .Range("B3:T" & .[B65536].End(3).Row)
End With
For i = 1 To UBound(arr)
If arr(i, 2) Like "*" & Me.TextBox1 & "*" Then
Set ITM = ListView1.ListItems.Add()
ITM.Text = arr(i, 1)
For j = 1 To 18
ITM.SubItems(j) = arr(i, j + 1)
Next
End If
Next
Label2 = "共发现数据:" & ListView1.ListItems.Count & " 条"
End Sub |
|