ActiveX

To sort the sheet based on a specific column using code

At run time,

1. Set the ColUserSortIndicator property as follows.
   1. Specify the column number using the Col parameter.
   2. Set the property to one of the following values to specify the sort method:
      • If you want to sort in ascending order, set the property to 1 (Ascending).
      • If you want to sort in descending order, set the property to 2 (Descending).
2. Set the UserColAction property to one of the following values to specify what action to perform:
   • If you want the column to be sorted and display the sort indicator, set the UserColAction property to 1 (Sort).
   • If you want the column to be sorted and not display the sort indicator, set the UserColAction property to 2 (SortNoIndicator).
3. If your sheet displays multiple headers and you want the sort indicator to display in a row other than the bottom-most header row, specify which column header row will display the indicator by setting the ColHeadersUserSortIndex property.