listbox number sorting

[dannyhar]

I have a listbox. When I press "Number" header, I want to sort correctly the "Number" column.

1,20
107,55
16,35
69,60

must be

1,20
16,35
69,60
107,55

Can somebody help me?

[nilem]

Hi dannyhar,
try changing this line in the Private Sub UserForm_Initialize()

Please Login or Register  to view this content.

if it is suitable for you

[dannyhar]

It is disturbing to show zeros in front of numbers. Could not occur without zeros?

[Andy Pope]

Use helper columns, which can been hidden, for sorting text as numbers.

[dannyhar]

Yes! This is better.
Thanks nilem, Thanks Andy Pope!