Hello everyone, I am relatively new to coding and have been learning as I go so forgive me if there is a very simple solution that I have yet to learn. So what I am trying to do is create a macro that will begin with a userform combo box giving the user an option to select a month and year. Then with this information, the rest of the macro code will change (or replace certain characters) based on this decision. For example, say the user chooses "April" "2014" in the userform combo boxes at the start of the macro, I would like the code in the rest of the macro to change to accommodate for that choice by replacing the code where there is a month to put in "April" and the places where there is a year to put in "2014." The reason I need this specifically to happen is because each month I do reporting and reference certain workbooks titled "Month Year", and if I can get that code to change based on what I choose in the userform then the macro will reference the proper workbook and find the correct information in that workbook. I am able to create the userform and the code for one month's worth of reporting but I cannot figure out how to change the code dynamically based on the decision. I'm trying to avoid making a separate macro for every possible month and year combination with this. I hope this makes sense, and I hope someone out there can give me some help on this issue (if it is even possible)

I appreciate any help or advice anyone can offer, thanks!