Wrox Programmer Forums
BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2
This is the forum to discuss the Wrox book Excel 2007 VBA Programmer's Reference by John Green, Stephen Bullen, Rob Bovey, Michael Alexander; ISBN: 9780470046432
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 11th, 2010, 01:02 AM
Registered User
Join Date: Jan 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default dropdowns on ListObjects

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.

 Application.CommandBars("List Range Popup").Controls(10).Controls(1)
 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.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Interdependent Dropdowns Yamini Javascript 7 January 8th, 2009 07:41 AM
Dynamic Dropdowns jasmine_vj Classic ASP Basics 2 April 17th, 2006 12:47 PM
Dropdowns in datagrid amithkiran ASP.NET 1.x and 2.0 Application Design 1 March 24th, 2005 05:33 AM
Three dropdowns, one depended on another. Possible gilgalbiblewheel Classic ASP Databases 2 December 26th, 2004 05:59 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.