Hi, I have had some big issues in trying to find the command bar name and CommandBarButton ids for the sort buttons on the autofilter menu displayed when clicking the dropdown buttons on the header of a listobject.
Can anyone help me with this?? The closest I've come so far is I found the ids of the buttons in the sort popout of the "Cell" and "List Range Popup" command bars. I also found others in the "Sort" commandbar..etc, but couldn't manage to find the name of the menu popup displayed when the user clicks on a dropdown in the listObject header.
e.g.
Code:
Application.CommandBars("List Range Popup").Controls(10).Controls(1)
or
Code:
Application.CommandBars.FindControl(msoCommandBarButton, 12947)
The reason I need this so bad is because I would like to capture the click events of the sort buttons (A..Z, Z..A) when the user decides to sort a listObject from the header dropdowns.
Some help on this would be greatly appreciated.
dropdowns on ListObjects
