|
本帖最后由 hwc2ycy 于 2013-1-16 11:01 编辑
针对输入的箱数进行筛选- Private Sub TextBox1_Change()
- Dim what As String: what = TextBox1.value
- ListView1.ListItems.Clear
- If what = "" Then
- For i = 1 To UBound(arr)
- Set itm = ListView1.ListItems.Add()
- itm.Text = arr(i, 1)
- itm.SubItems(1) = arr(i, 2)
- itm.SubItems(2) = arr(i, 3)
- itm.SubItems(3) = arr(i, 4)
- itm.SubItems(4) = Format(arr(i, 5), "0.00")
- Next i
- Else
- Dim dic As Object
- Set dic = CreateObject("scripting.dictionary")
- For i = 1 To UBound(arr)
- If arr(i, 3) Like "*" & what & "*" Then
- If Not dic.exists(arr(i, 1)) Then
- dic.Add arr(i, 1), ""
- Set itm = ListView1.ListItems.Add()
- itm.Text = arr(i, 1)
- itm.SubItems(1) = arr(i, 2)
- itm.SubItems(2) = arr(i, 3)
- itm.SubItems(3) = arr(i, 4)
- itm.SubItems(4) = Format(arr(i, 5), "0.00")
- End If
- End If
- Next
- End If
- Label2.Caption = "共找到 " & ListView1.ListItems.Count & " 条记录"
- Set dic = Nothing
- End Sub
复制代码 |
评分
-
查看全部评分
|