Just use a commandbutton and use a static variable to remember what was the
last sort column. Then put in a case statement to do the new sort based on
the stored column, change the caption on the button to the next sort, record
the column used (set the variable).

--
Regards,
Tom Ogilvy

"stakar " wrote in message
...
I have the following problem
I want to sort a column by using the togglebutton with the triplestate
turned to True

So if i click on the togglebutton once to be sorted by A
If i click second time to be sorted by B
and at last if i click for third time to be sorted by C

Is it possible? Because i cant manage it
Thanks in advance

Stathis


---
Message posted from http://www.ExcelForum.com/