Sort Listbox in Userform

[s2jrchoi]

VBA Experts,

I need your help! My listbox values consists of Invoice numbers that start either with an alphabet letter (D00102) or with just numbers (200001). I found this code below online but I can't get it to sort it by numbers first then letters. For example, I would like the listbox to show:

1000001
1000002
2000001
3000001
4000001
W00001
Z000001

Please Login or Register  to view this content.

Can anyone help please?

Thank you!!

[Norie]

Can we see the values before they are sorted?

[millz]

maybe try this:

Please Login or Register  to view this content.

[s2jrchoi]

That worked!!! Thank you so much!!!! I will mark this as solved!