I have a Listbox "on a form" populated by several dynamic ranges pulling from several worksheets. I have already figured out how to take out all duplicates from the Listbox. I have also managed to try several different methods of sorting my information. However, I always seem to come up short of my goal.
It is a single column list.
The list has both numeric and Alpha-Numeric text entries.
Sorting by A-Z gives me number orders like this: 2, 3, 31, 32, 4
and sorting Numerically gives me even more issues.
So far, I have read several posts of small mentions of Leading-0 sorting, and I have seen one post that talks about "Sorting Complex Alpha-Numeric Strings." I would NOT like to copy the whole list back to a worksheet!
Can anyone help me come up with some code to sort a Listbox using Leading-0's? .... without changing the final text of the list... possibly a bubble sort or something?
It is a single column list.
The list has both numeric and Alpha-Numeric text entries.
Sorting by A-Z gives me number orders like this: 2, 3, 31, 32, 4
and sorting Numerically gives me even more issues.
So far, I have read several posts of small mentions of Leading-0 sorting, and I have seen one post that talks about "Sorting Complex Alpha-Numeric Strings." I would NOT like to copy the whole list back to a worksheet!
Can anyone help me come up with some code to sort a Listbox using Leading-0's? .... without changing the final text of the list... possibly a bubble sort or something?
Last edited: