If you’re really sorting those columns numerically, then you’ve implemented the CompareRows event. Look there to make sure you’re not returning True for the other columns. A typical mistake is to throw Return True at the end of the event instead of just for the columns you’re handling yourself.
What Jim is saying is with the standard settings, a listbox sort is by string values.
So a list with 1, 3, 100, 20, 300, 2 would be sorted as strings rather than numbers.
as: [1, 100, 2, 20, 3, 300]
not: [1, 2, 3, 20, 100, 300]
You’ll have to manually implement the sort function to get the numbers to sort as numbers.
And please define “don’t sort worth a hoot”. Your initial post indicated they didn’t sort at all. Give some sample data and how it looks before and after sorting.