Vikas,
I don't understand your answer. Let me see if I can make my situation clearer:
User opens "Staffing Projection Tool.xls", which opens "Paid FTEs.xls", which contains the pivot table in question. Userform comes up, asks user which Region they want. User selects, for instance, region 030. Macro selects region 3 in pivot table, makes some other modifications to pivot, then it needs to know what dates to use. I don't want my user interacting with the spreadsheet, but the user needs to select the dates to use. That was why I asked for a listbox. If we can do it with a combobox that's just fine, I just don't understand how. Below is the code I'm trying to use.
Bookmarks