以下是引用sendsend在2010-7-22 22:51:00的发言:原来的listview里输入任一字符,只要所显示的所有的列中的任一列中包含该字符,就把该列包含输入字符的所在行都显示出来! Private Sub TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) ListView1.ListItems.Clear Call 添加标题行 Call saixuan(ComboBox1.Text) For x = 1 To UBound(arr1, 2) If arr1(2, x) Like "*" & TextBox1.Text & "*" Or arr1(1, x) Like "*" & TextBox1.Text & "*" Or arr1(3, x) Like "*" & TextBox1.Text & "*" Or arr1(4, x) Like "*" & TextBox1.Text & "*" Then Set ITM = ListView1.ListItems.Add() ITM.Text = arr1(1, x) ITM.SubItems(1) = arr1(2, x) ITM.SubItems(2) = arr1(3, x) ITM.SubItems(3) = arr1(4, x) End If Next x End Sub |