So I took it upon myself to figure it out! So here i go for the next person!
--let make it "Clear" I am using Excel 2007!
You need to fill the Combo box control with all the pivot item of the filter field and a "(All)" item, and then add a change event for that combo box control.
Put these two procedure within the module which the combo box control locate at, run the first procedure "FillComboBox", and then select a item from dropdown list of the combo box control, you would see that the pivottable also would update.
If you need to ask me how to tie in multi pivot tables message me.
Bookmarks