Populate Ribbon Controls On Load Dynamically Through VBA Variables

[phxpoolplayer]

I am working with custom ribbons for an Excel file that i am working on. I have got to the point where i can Load the ribbons/controls and have them function as expected. My question is, however, how do you dinamically change list items in a control based on the end user response. For example, I want a control for month and year (Jan 13 - Dec 13). But, I want it to be limited to a variable of my choosing. Lets say I only want to display Jan 13 - Mar 13 because May 13 isn't here yet. But next month, i want it to list May due to a particular user action.

I hope this is clear enough and thanks in advance for anyones help.

Patrick

[Excel Fox]

Have a look at the Chronos Twelve Add-in in this forum. If you know what you're doing, you'll be able to figure out exactly what I've done to create a dynamic ribbon. You can adapt it to build anything feasible within the ribbon realm.

If you still aren't able to figure things out, post your file, let me know exactly what you are trying to do.