sorting multi column listbox

Originally Posted by pike

Hi ali84pk
With a workbook maybe this link will help
http://www.sqldrill.com/excel/progra...-vba-code.html

Dear Pike,

thanks for help. It seems, that your provided code are exactly what I am looking for.
I tried those code, but facing error of ByRef argument type mismatch. on "lst1"

Please Login or Register  to view this content.

can you please advice, what is reason.

thanks

Dear pike

Please find attachment of file. I need one macro to sort listbox by
"agent name" and one macro to sort by Amount".


Thanks

Dear Pike

Thanks for your all efforts :-), 50% of job is 100% done.

I can sort as per agent column but not as per amount column.

I have noticed, if I put value manually in amount column, it works fine in sorting as per amount column. But if I paste my original data, it gives error.

I have pasted original data in example file so that you can see the error. Can you please assist on this.

Once again thanks a lot. You have saved my a lot of time.

Thanks

Dear Pike,

Thanks for prompt reply. Error is solved but sorting is as per first digit only, not as per whole amount value

Sorry to bother you

Need your help again

Thanks

Dear Snb,

Thanks for your contribution in helping me. Actually in my project, I have to fill listbox in outlook form also. therefore I can't use this alternative approach. Please help me in modifying this approach in which I am almost done.

Dear Pike,
Problem is still same, it sorts amount column on base of first digit.
for example:
10
200
1000
500

macro sorts as :

10
1000
200
500

Thanks

ali84pk. In the Private Sub UserForm_Initialize() procedure, try this line

Please Login or Register  to view this content.

written as

Please Login or Register  to view this content.

Originally Posted by pike

Hmmm,, it works with the data

WOW!! Pike you are Superman!! .Thank you very much! for your all efforts.
It's working like charm

Thanks