Sort and Reverse—Sort a ListView

Sort and Reverse—Sort a ListView

This routine performs the standard column sorting on a ListView control found in many commercial applications, such as Windows Explorer and Outlook. Using this routine, the ListView sorts itself automatically whenever the user clicks on a column. Clicking on the same column toggles the sort order between ascending and descending order. Call this routine from the ListView controls ColumnClick event procedure by passing both a reference to the ListView and the ColumnHeader reference passed to the original event:

 Public Sub ListView_ColumnClick(ByRef _MyListView As ListView, ByVal ColumnHeader _As ColumnHeader)With MyListView.Sorted = FalseIf .SortKey <> ColumnHeader.Index - _1 Then.SortKey = ColumnHeader.Index - 1.SortOrder = lvwAscendingElseIf .SortOrder = lvwAscending Then.SortOrder = lvwDescendingElse.SortOrder = lvwAscendingEnd IfEnd If.Sorted = TrueEnd WithEnd Sub
Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular