|
发表于 2011-12-26 12:30
|
显示全部楼层
本楼为最佳答案
本帖最后由 liuguansky 于 2011-12-26 12:35 编辑
- Option Compare Text
- Private Sub ComboBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
- With ComboBox1
- Dim a$, k As Byte, t$, Arr() As String, Ar() As String, i&
- a = Dir(ThisWorkbook.path & "\方法\*.xls")
- If Len(a) Then
- t = a
- Do
- k = k + 1: ReDim Preserve Arr(1 To k)
- Arr(k) = a
- a = Dir()
- Loop Until a = t Or Len(a) = 0
- End If
- a = "*" & .Value & "*"
- k = 0
- For i = 1 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
复制代码
试下这个事件,支持大小写,中文部分匹配。
|
评分
-
查看全部评分
|