|
本帖最后由 today0427 于 2016-9-14 06:21 编辑
考虑到虽然你现在未出现小数部分,但是折扣后肯定会出现,我昨天的代码是有缺陷的,修改了下,楼主测试一下 - Private Sub ListView1_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader)
- Dim i&, c%
- With ListView1
- c = ColumnHeader.Index - 1
- If c > 2 Then
- For i = 1 To .ListItems.Count
- .ListItems(i).SubItems(c) = Format(.ListItems(i).SubItems(c), "0000000000.00")
- Next
- End If
-
- .SortKey = c
- .SortOrder = IIf(.SortOrder, 0, 1)
- .Sorted = True
- If c > 2 Then
- For i = 1 To .ListItems.Count
- .ListItems(i).SubItems(c) = IIf(Val(.ListItems(i).SubItems(c)) = 0, "", Format(.ListItems(i).SubItems(c), "0.00"))
- Next
- End If
- End With
- End Sub
复制代码
|
|