ExcelBanter - How do I alternate a sort from a text box via macros?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I alternate a sort from a text box via macros? (https://www.excelbanter.com/excel-programming/331298-how-do-i-alternate-sort-text-box-via-macros.html)

g.a.

How do I alternate a sort from a text box via macros?

I have a column of data that I am using a text box to run a macro that sorts
the data in descending order. How can I alternate the sort criteria
(ascending/descending) using the same text box? Push once - sort in
ascending order; push again - sort in descending order. Thanks.

All times are GMT +1. The time now is 11:22 AM.