VBA - How to retrieve current dropdown setting in custom MS Office Ribbon menu
Working in Microsoft PowerPoint 2010, I have a custom ribbon menu (toolbar), and I'm using dropdown controls. I want the user to be able to select a search keyword, which they narrows down the graphics that appear on a dropdown gallery in the button next to it.
Currently I have an onAction macro associated with the dropdown that changes a public variable each time the dropdown is changed. then the gallery button filters based on that public variable. How do I accomplish this without relying on a public variable?. In other words, when the user hits the gallery button, I'd like it to read the current setting of the ribbon dropdown and create the filtered set at that time.