|
发表于 2021-8-27 15:51
|
显示全部楼层
本楼为最佳答案
你这是套用别人的代码吧?里面稍改一下就就以了。只帮你改了一个数字
Sub 查询(Lvw As ListView, Firstdate As Date, Lastdate As Date, Index As String)
Dim arr()
Dim Item As ListItem
Dim i As Integer
Dim n As Byte
Dim Hj As Long
arr = Sheet1.Range("A2:J" & Sheet1.Range("A65536").End(xlUp).Row)
With Lvw.ListItems
.Clear
For i = 1 To UBound(arr)
If arr(i, 9) = Index And arr(i, 7) >= Firstdate And arr(i, 8) <= Lastdate Then
Set Item = .Add()
Item.Text = arr(i, 1)
For n = 2 To 10
Item.SubItems(n - 1) = arr(i, n)
Next
End If
Next
For i = 1 To .Count
Hj = Hj + .Item(i).ListSubItems(5).Text
Next
Set Item = .Add()
With Item
.SubItems(1) = "数量合计:"
.SubItems(5) = Hj
.SubItems(7) = ""
.ListSubItems(1).Bold = True
.ListSubItems(1).ForeColor = vbRed
.ListSubItems(5).Bold = True
.ListSubItems(5).ForeColor = vbRed
End With
QueryFrm.TextBox2.Text = Hj
End With
End Sub |
|