Which Column is being Sorted By ?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   In Outlook the rows are grouped by the Column Header that is clicked I want to recreate the same functionality.
How can I determine which column has been clicked - the control (v9.61) only triggeres as the column header is "Right Clicked" - which is really no good.
So - within the wndReportControl_SortOrderChanged Sub I would like to determine which column is the sorted column and then use that as the groupable column.
e.g. WndReportControl.GroupsOrder.Add TheColumnWeWant
TIA
Lee

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
LeeHayton Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25 November 2005 Location: United Kingdom Status: Offline Points: 102	Post Options Post Reply Quote LeeHayton Report Post Thanks(0) Quote Reply Topic: Which Column is being Sorted By ? Posted: 02 February 2006 at 10:31am
	In Outlook the rows are grouped by the Column Header that is clicked I want to recreate the same functionality. How can I determine which column has been clicked - the control (v9.61) only triggeres as the column header is "Right Clicked" - which is really no good. So - within the wndReportControl_SortOrderChanged Sub I would like to determine which column is the sorted column and then use that as the groupable column. e.g. WndReportControl.GroupsOrder.Add TheColumnWeWant TIA Lee

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 03 February 2006 at 12:19pm
	Take a look at this: Private Sub wndReportControl_SortOrderChanged() Debug.Print wndReportControl.SortOrder.Column(wndReportControl.SortOrder .Count - 1).Caption & " was just sorted" End Sub