Newer to VBA
I have a UserForm with 2 ComboBox options. It gives the Month and the Year. I also have a line of code that I want the UserForm to run depending on what Month and Year are choose.
How do I get the code to say....If May and 2011 are chosen, then the May 2011 code is run. If June and 2012 are chosen, then the June 2012 code is run.
The code is a recorded marcro that goes to a pivot table from anoter file and filters the table to certain criteria (including month and year) and copies subtotals and pastes them in the current workbook. Will this go in a module or in the UserForm (Code).
Again, I am very new to Macros and don't know much. I have learned everything from recording macros, looking at forums, and skimming through "Excel Macros VBA for Dummy's." However, I am still stuck.
Bookmarks