|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
两位小数点
Private Sub UserForm_Initialize()
Dim arr, i&, j&
arr = Sheet3.Range("A1:E10")
Me.ListView1.View = lvwReport '报表格式
Me.ListView1.Gridlines = True '网格线
Me.ListView1.CheckBoxes = True '显示复选框
Me.ListView1.FullRowSelect = True '整行选择
Me.ListView1.MultiSelect = True '多项选项
For i = 1 To UBound(arr, 2)
Me.ListView1.ColumnHeaders.Add Text:=arr(1, i)
Next i
For i = LBound(arr) + 1 To UBound(arr)
With Me.ListView1.ListItems.Add(Text:=arr(i, 1))
For j = LBound(arr, 2) To UBound(arr, 2) - 1
If j = 3 Or j = 4 Then
.SubItems(j) = Format(arr(i, j + 1), "##,#,0.00")
Else
.SubItems(j) = arr(i, j + 1)
End If
Next
End With
Next
End Sub
|
评分
-
1
查看全部评分
-
|