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