|
本帖最后由 liuguansky 于 2012-3-9 09:14 编辑
wen980203 发表于 2012-3-8 19:27
你好,我的附件已上传,还请帮忙,谢谢!
- Option Compare Text
- Private Sub ComboBox2_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
- With ComboBox2
- Dim a$, k&, Arr, Ar() As String, i&, d As New Dictionary
- Arr = Range("a1:a" & Cells(Rows.Count, 1).End(3).Row).Value
- For i = 1 To UBound(Arr)
- d(Arr(i, 1)) = ""
- Next i
- a = "*" & Trim(.Value) & "*"
- Arr = d.Keys
- k = 0
- For i = 0 To UBound(Arr)
- If PINYIN(Arr(i)) Like a Or Arr(i) Like a Then
- k = k + 1: ReDim Preserve Ar(1 To k)
- Ar(k) = Arr(i)
- End If
- Next
- If k > 0 Then
- .List() = Ar
- Else: .Clear
- End If
- End With
- End Sub
复制代码
模糊查询.rar
(21.16 KB, 下载次数: 11)
|
|