I have a listbox and have implemented
Select Case column
If Val( me.Cell(row1, 8 )) < Val( me.Cell(row2, 8)) Then
result = -1
ElseIf Val(me.Cell(row1, 8)) > Val( Me.Cell(row2, 8)) Then
result = 1
result = 0
I have noticed if I have numbers that are the same, so say the numeric column contains 1,4,3,5,5,6,7 that if I sort by text using another column then revert back to sort the numeric column that the rows containing 5 in this example are not always in the same row, they can change position.
Why is that and how can I ensure that when I sort the numeric column I get a consistent result?