Codejock Developer Community : Which Column is being Sorted By ?

Codejock Developer Community : Which Column is being Sorted By ? http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 00:52:17 +0000 Fri, 03 Feb 2006 12:19:53 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=3588 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Which Column is being Sorted By ? : Take a look at this:Private Sub...]]> http://forum.codejock.com/forum_posts.asp?TID=3588&PID=10801&title=which-column-is-being-sorted-by#10801 Author: SuperMario
Subject: 3588
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]]> Fri, 03 Feb 2006 12:19:53 +0000 http://forum.codejock.com/forum_posts.asp?TID=3588&PID=10801&title=which-column-is-being-sorted-by#10801 <![CDATA[Which Column is being Sorted By ? : In Outlook the rows are grouped...]]> http://forum.codejock.com/forum_posts.asp?TID=3588&PID=10771&title=which-column-is-being-sorted-by#10771 Author: LeeHayton
Subject: 3588
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

]]> Thu, 02 Feb 2006 10:31:20 +0000 http://forum.codejock.com/forum_posts.asp?TID=3588&PID=10771&title=which-column-is-being-sorted-by#10771