Sort in descending order

Hi,

I have a userform that is capturing scores for different students. I need to make it such like as and when user clicks on “Save” button. He will get a Mesgbox showing the name and score of each student in descending order basis score.

Viz… Marks entered in textboxs are 56,89,69,98,78

Then the result shows as :

<Name of Candidate1> 98
<Name of Candidate2> 89
<Name of Candidate3> 78
<Name of Candidate4> 68
<Name of Candidate5> 56

Later the result will get store in worksheet.


Please help…

Regards,
Shane