|
- Private Sub 查询_Click()
- ListView1.ListItems.Clear
- ListView1.ColumnHeaders.Clear
- With Sheets("明细")
- Dim i, 合计金额C, j&
- Dim itm As ListItem, list
- ListView1.ColumnHeaders.Add 1, "riqi", "日期", 80
- ListView1.ColumnHeaders.Add 2, "bianhao", "编号", 55, lvwColumnCenter
- ListView1.ColumnHeaders.Add 3, "danwei", "单位", 150, lvwColumnCenter
- ListView1.ColumnHeaders.Add 4, "zhaiyao", "摘要", 100, lvwColumnCenter
- ListView1.ColumnHeaders.Add 5, "shoukuanfangshi", "收款方式", 60, lvwColumnCenter
- ListView1.ColumnHeaders.Add 6, "jine", "金额", 75, lvwColumnRight
- ListView1.ColumnHeaders.Add 7, "beizhu", "备注", 100, lvwColumnCenter
- ListView1.ColumnHeaders.Add 8, "zuofei", "作废", 40, lvwColumnCenter
- ListView1.View = lvwReport
- ListView1.Gridlines = True
- For i = 1 To Sheets("明细").Cells(65536, 1).End(xlUp).Row
- 'If Sheets("明细").Cells(i, 1) >= 起始时间 And Sheets("明细").Cells(i, 1) <= 结束时间 Then
- '单位C.Text = "" Then
- 'ElseIf Sheets("明细").Cells(i, 3) = 单位C.Text Then
- Set itm = ListView1.ListItems.Add()
- With itm
- .Text = Sheets("明细").Cells(i, 1)
- .SubItems(1) = Sheets("明细").Cells(i, 2)
- .SubItems(2) = Sheets("明细").Cells(i, 3)
- .SubItems(3) = Sheets("明细").Cells(i, 4)
- .SubItems(4) = Sheets("明细").Cells(i, 5)
- .SubItems(5) = Format(Sheets("明细").Cells(i, 6), "#,##0.00")
- .SubItems(6) = Sheets("明细").Cells(i, 7)
- .SubItems(7) = Sheets("明细").Cells(i, 8)
- If .SubItems(7) = "作废" Then
- .ForeColor = vbRed
- For j = 1 To .ListSubItems.Count
- .ListSubItems(j).ForeColor = vbRed
- Next
- End If
- 合计金额C = 合计金额C + Val(Sheets("明细").Cells(i, 6))
- End With
- 'End If
- Next i
- Set itm = ListView1.ListItems.Add()
- With itm
- .Text = "合计金额:"
- .ForeColor = vbRed
- .SubItems(2) = Format(合计金额C, "#,##0.00")
- .ListSubItems(2).ForeColor = vbRed
- End With
- End With
- End Sub
复制代码 红字显示方式。
|
|