Hello,
The problem is the following:
I have a listbox in a userform, which I populate from an excel sheet through array. The problem is that in the sheet there are prices which
when I put into the listbox automatically converted to string. (So the numbers shown as string). Becouse of this I cannot sort about price
becouse its not number but string.
This is how I populate the listbox:
I try to sort with this code:Please Login or Register to view this content.
The sort function is working "great" but becouse of the strings its not sorted by value its sorted by abcPlease Login or Register to view this content.
1045
2112
2567
299123
320
345000
391
Has anyone got any ideas?
Bookmarks