|
发表于 2013-5-11 22:48
|
显示全部楼层
本楼为最佳答案
USERFORM3的窗体初始化代码完整。- Private Sub UserForm_Initialize()
- Dim i As Long, r As Long, k As Integer, ar As Variant
- Dim bool As Boolean, gsl As Single
- For i = 1 To 19
- ComboBox2.AddItem Format(i * 0.05, "0.00")
- Next
- With Sheets("Sheet1")
- r = .Range("a65536").End(xlUp).Row
- ar = .Range("a4:h" & r)
- End With
- With ListView2
- .View = lvwReport
- .Gridlines = True
- .FullRowSelect = True
- .CheckBoxes = True
- .ColumnHeaders.Add , , " " & ar(1, 2), .Width / 3.5
- .ColumnHeaders.Add , , ar(1, 3), .Width / 2.8, lvwColumnCenter
- .ColumnHeaders.Add , , "管理费 ", .Width / 6, lvwColumnRight
- .ColumnHeaders.Add , , "计费金额", .Width / 6, lvwColumnRight
- .ColumnHeaders.Add , , "", .Width / 45, lvwColumnRight
- For i = 2 To UBound(ar)
- If Not IsNumeric(ar(i, 1)) Then
- bool = True
- k = k + 1
- .ListItems.Add , , ar(i, 2)
- .ListItems(k).SubItems(1) = ar(i, 3)
- ElseIf ar(i, 2) = "管理费" Then
- bool = False
- .ListItems(k).SubItems(2) = Format(ar(i, 7), "0.00")
- .ListItems(k).SubItems(3) = Format(gsl, "0.00")
- .ListItems(k).SubItems(4) = "G" & i + 3
- gsl = 0
- End If
- If bool = True Then
- If Not ar(i, 2) = "工税利" Then gsl = gsl + ar(i, 7)
- End If
- Next i
- .SelectedItem.Selected = False
- End With
- End Sub
复制代码 |
评分
-
查看全部评分
|