|
试试:
- Private Sub TextBox1_Change()
- If TextBox1.Text = "" Then
- Me.UsedRange.Offset(4).EntireRow.Hidden = False
- Exit Sub
- Else
- Me.UsedRange.Offset(4).EntireRow.Hidden = True
- End If
- Dim arr, rng As Range, i&, j&, m&, t$
- arr = Me.UsedRange
- t = TextBox1.Text
- For i = 5 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If InStr(arr(i, j), t) Then
- m = m + 1
- If m = 1 Then Set rng = Cells(i, 1) Else Set rng = Union(rng, Cells(i, 1))
- Exit For
- End If
- Next
- Next
- If m > 0 Then
- Me.UsedRange.Offset(4).EntireRow.Hidden = True
- rng.EntireRow.EntireRow.Hidden = False
- End If
- End Sub
复制代码 |
|