Sort userform list based on option button selection

I'm looking for suggestions to sort a user form list based on which option button is selected. It's not the most elegant of solutions so any suggestions would be greatly appreciated. I have also inclued an image of how the user form looks.

Once the user has selected an item from the list the "Load Info" button loads the requested info into another user form. But i now need to provide an option on how the list is sorted to help the user.

Thanks

userform.PNG

Please Login or Register  to view this content.

I will probably just re-write to have two seperate user forms with the specific sort in each, then i will provide 2 2 buttons on worksheet specific to each sort type.

I have a further question regarding filtering the data loaded into the combo box which i will post as new.

Thanks for your help

Please Login or Register  to view this content.