|
说明你还是没看懂!
修改以下语句:(比原来简化了一点)
Private Sub TextBox1_Change()
Dim I&, Arr, d
Dim myStr As String
Set d = CreateObject("Scripting.Dictionary")
Me.ListBox1.Clear
Arr = Sheet1.[B6].CurrentRegion
For I = 1 To UBound(Arr)
If InStr(Arr(I, 2), TextBox1.Value) Then d(Arr(I, 2)) = ""
Next
With ListBox1
.Visible = True
.Top = Selection.Offset(1).Top
.Left = Selection.Offset(0, 0.8).Left
.Width = Selection.Width * 2
.Height = Selection.Height * 5
End With
Me.ListBox1.List = d.KEYS
End Sub
其中红色语句就是提取数据区的语句,可修改成任何工作表。 |
|