|
Private Sub TextBox1_Change()
Dim arr, crr, r%, Arr1(), j&, x&
On Error Resume Next
ListBox1.Clear
TextBox1.TopLeftCell = TextBox1.Text
If TextBox1 = "" Then Exit Sub
crr = Sheets("联系人").[c3].CurrentRegion
For i = 2 To UBound(crr)
aa = ""
For j = 1 To UBound(crr, 2)
If InStr(crr(i, j), TextBox1.Text) Then
r = r + 1
ReDim Preserve Arr1(1 To r)
For x = 1 To UBound(crr, 2)
aa = aa & crr(i, x) & vbTab
Next
Arr1(r) = aa
End If
Next
Next
If r > 0 Then
ListBox1.List = Arr1
End If
End Sub
这段代码指定的是在哪列输入?怎么能更改成别的列输入? |
|