After a couple of shots I finally solved it. I used the this http://www.datapigtechnologies.com/f...s/pivot10.html, but added the code that was missing that calls the event from another sheet.
Originally Posted by bayzano
This is the macro that should be assigned to the Combo Box after following the instructions in the link above.
This works great for Excel 2007.
REPLACE: "PivotTableSheet" by the name of the sheet where your Pivot Tables are and "Filtered Value" with the filter of the Pivot Table you want to manipulate with the Combo Box.
Hope I was clear.