Control Pivot filter by From ComboBox

[MarkCBB]

Hi there,

I need some code to control a Pivot table filter from a form comboBox.

The combo box is going to be located on a chart, with the contents being a unique list of people, the combo box selection should change the pivot table filter to the same person.

I have no idea where to start, currently I have too go the the pivot table every time to change it.

 

[Jerry Sullivan]

Hi Mark,

The code in this thread might help you get started.
http://www.mrexcel.com/forum/showthread.php?t=519947
That shows a method of using Checkboxes to control PT filters.
Let me know if you need some help adapting that to use a ComboBox instead.

 

[Marcelo Branco]

Maybe this can help

http://www.datapigtechnologies.com/flashfiles/pivot10.html

M.

 

[parkerbelt]

Maybe this can help

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

M.

I just used this link, it works great.
Thank you!