Macro for Sorting

[BrettW]

I have created a spreadsheet with a few command buttons to sort the data. One of the gentlemen that will be reviewing this sheet can never remember how to sort correctly, so spreadsheets often get scrambled after he gets a hold of it. Anyway, I used the macro recorder to create the code, but I don't know how to let him sort ascending / descending. I added a couple of radio buttons for him to select, then click the button of the appropriate column. Can anyone help with the code to make it function depending on which radio button is selected. Thanks.

[Leith Ross]

Hello BrettW,

In Module1 I have added a Public Variable Direction. This is used in the Sort method to replace the xlAscending and xlDescending values. Ascending is the default whenever the workbook opens. Here is the Data worksheet controls code...

Data Worksheet Controls Code

Please Login or Register  to view this content.

Module1 Code

Please Login or Register  to view this content.

ThisWorkbook Event Code

Please Login or Register  to view this content.

[BrettW]

Thanks Leith, it works great.