|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 zjdh 于 2013-1-20 09:47 编辑
Private Sub TextBOX1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Dim I&, t%, k&, N$, Arr1()
Me.ListBox1.Clear
arr2 = Array("账号", "收 款 单 位", " ", "开户行")
k = k + 1
ReDim Arr1(1 To 4, 1 To k)
For I = 1 To 4
Arr1(I, k) = arr2(I - 1)
Next
For I = 1 To UBound(Arrsj)
N = Arrsj(I, 1) & " " & Arrsj(I, 2) & " " & Arrsj(I, 4)
If InStr(N, UCase(Me.TextBox1.Value)) Then
k = k + 1
ReDim Preserve Arr1(1 To 4, 1 To k)
For t = 1 To 4
Arr1(t, k) = Arrsj(I, t)
Next
End If
Next I
If t = 0 Then Exit Sub
Me.ListBox1.List = Application.Transpose(Arr1)
End Sub |
评分
-
1
查看全部评分
-
|