本帖最后由 深秋的黎明 于 2019-12-28 18:26 编辑
★★★划重点啦!
在textbox窗口里实现模糊查询功能
Private Sub TextBox1_Change()
Dim i&, j%, t%, myStr$, k&, n$, P$, S$
Dim LG As Boolean, ARR1()
With Sheets("商品目录")
Myr = .[B7000].End(3).Row
Arrsj = .Range("A2:J" & Myr)
End With
Me.ListBox2.Clear
myStr = UCase(Me.TextBox9.Value)
For i = 1 To Len(myStr)
If Asc(Mid$(myStr, i, 1)) < 0 Then LG = True: Exit For
Next
tr = 1
ReDim ARR1(1 To Myr, 1 To 10)
For R = 1 To UBound(Arrsj)
For c = 1 To UBound(Arrsj, 2)
If Arrsj(R, c) Like "*" & TextBox9 & "*" Then
tr = tr + 1
ARR1(tr, 1) = Arrsj(R, 1)
ARR1(tr, 2) = Arrsj(R, 2)
ARR1(tr, 3) = Arrsj(R, 3)
ARR1(tr, 4) = Arrsj(R, 4)
ARR1(tr, 5) = Arrsj(R, 5)
ARR1(tr, 6) = Arrsj(R, 6)
ARR1(tr, 7) = Arrsj(R, 7)
ARR1(tr, 8) = Arrsj(R, 8)
ARR1(tr, 9) = Arrsj(R, 9)
ARR1(tr, 10) = Arrsj(R, 10)
Exit For
End If
Next
Next
Me.ListBox2.List = ARR1
If Len(TextBox9.Value) < 5 Then ’这里是对字节的限制
Me.ListBox3.Clear
Else
End If
End Sub |