Hello,

I have developed a combo box that lets a user chose an employee. Each employee has some programs and then program data that changes over time. I am trying to have the user chose the employee and then 2 data set dates (as contained in the underlying data) and then create a pivot table comparing the two dates.

I am having a very hard time on setting the 2 dates to compare. If I record a macro everything is fine, except it uses the pivotItems visible true/false approach. I am trying make the pivot filter to be the date variable chosen by the user.

With my limited VBA skills whenever I try to reference the combo box response as a variable i get the dreaded "Unable to get pivot type property". The really frustrating thing is that I got this method to work like a charm on the employee combo box chosen as a page field.

Any help would be greatly appreciated

HTML Code: