How to set buttons for sorting if there are already fileters?

**toplisek** · 09-27-2013, 04:07 AM

I have columns and set filters. Some tasks can be faster if I set simple button to sort by date, priority etc.
How to do this as there are the following steps:
1. Click on button
2. Sort first column and than second and leave others...

So, filters are set but how to set button to sort only some columns. Example:
Button sort by date will sort only By date and Priority column and leave others.

**tehneXus** · 09-27-2013, 10:21 AM

Hi,

please check attached file for an example VBA code.

**toplisek** · 10-08-2013, 07:13 AM

I try to insert your visual basic. What are the correct steps to insert my visual basic into existing excel sheet?

As I understand there is
1. XLSM file with the
2. Design Mode and cmdsort (click action) and Worksheet (selection change action)

Need help.