error in listview fill items

User avatar
sal21
PlatinumLounger
Posts: 4341
Joined: 26 Apr 2010, 17:36

error in listview fill items

Post by sal21 »

Have an idea?

Code: Select all

Private Sub PopulateListView()

    Dim oldExStyle As Long
    Dim i As Integer
    Dim st As String
    Dim tmp As Single
    Dim lvItem As ListItem
    Dim j As Integer

    LockWindowUpdate ListView1.Hwnd

    ListView1.ColumnHeaders(4).Width = 0

    For i = 1 To 30
        Set lvItem = ListView1.ListItems.Add(i, , "This item contains text " & i, 3, 3)
        With lvItem
            .Tag = ""
            st = Format$(DateSerial(2005, 1, 31 - i), "dd.mm.yyyy")
            .ListSubItems.Add 1, , st
            .ListSubItems(1).Tag = Format$(st, "yyyymmddHHMMSS")<<<<<< error here
            tmp = Rnd * 10000
            .ListSubItems.Add 2, , Format$(tmp, ".0000")
            .ListSubItems(2).Tag = Format$(tmp, "000000000000.0000000000")
            .ListSubItems.Add 3, , ""
            .ListSubItems(3).Tag = ""
            .SmallIcon = 1
            .Bold = (i Mod 3 = 0)
            .ListSubItems(1).Bold = (i Mod 3 = 0)
            .ListSubItems(2).Bold = (i Mod 3 = 0)
            If i Mod 4 = 0 Then
                .ForeColor = vbRed
                For j = 1 To .ListSubItems.Count
                    .ListSubItems(j).ForeColor = vbRed
                Next
            End If
        End With
    Next

    ListView1.SortOrder = lvwDescending
    ListView1.ListItems(1).Selected = True

    LockWindowUpdate 0&
    
End Sub

You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78386
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: error in listview fill items

Post by HansV »

Does it work if you use

Code: Select all

            .ListSubItems(1).Tag = Format$(DateSerial(2005, 1, 31 - i), "yyyymmddHHMMSS")
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4341
Joined: 26 Apr 2010, 17:36

Re: error in listview fill items

Post by sal21 »

HansV wrote:
09 Jul 2020, 14:53
Does it work if you use

Code: Select all

            .ListSubItems(1).Tag = Format$(DateSerial(2005, 1, 31 - i), "yyyymmddHHMMSS")
:cheers: :cheers: :cheers: :cheers: