I have a question similar to one that has been posted before but I tried all
those answers and couldn't get it to work. I have...let's say...12 different
macros, one for each month of the year, that I can assign to buttons and they
work fine. Jan07, Feb07, and so on. On sheet2 in my workbook, Cells F9 and
G9 are merged together and contain a data validation drop down list of those
months. What I would like is that when January-07 is selected, it will run
Jan07, when February-07 is selected it will run Feb07, and so on. One thing
I thought may be affecting it is the fact that when I select a month from the
drop down list, I see it as "January-07" but it seems as though excel has it
as 1/1/2007. Meaning, if I double click the cell to modify it, it would
change from "January-07" to "1/1/2007".

Any help would be greatly appreciated.

Thanks,
Scott