Userform Command button to Sort

[zplugger]

Is it possible to have commandbutton on userform1 to sort listbox data and stay on userform. The data for the listbox is on a worksheet. when I sort it go to data range,what to stay on userform?

 

[akram-5]

did you try to sort the data in the worksheet before you send the data to list box

 

[zplugger]

I input data in the userform which fill the listbox,was hoping to sort the data a to z while staying in userform if possible.

 

[akram-5]

i dont know a straight way.. but you can create a button("Sort A-Z") in which you can copy the same data to a new sheet and sort it there. and then bring it to the list box.
to sort the data try recording a macro...

hope it helps..
AK