Scrollbar to change Pivot Table Date Filter

[jimreynolds64]

Hi.

I am relatively new to VBA/Macros etc, and am struggling with this problem.

I want to have a scroll bar that changes the pivot table filter so that I can scroll between dates, and what was performed on these dates - so that when I put this in a chart, it only shows the date the scrollbar says.

I am working in Excel 2007. A link to the excel document is below:
Scrollbar to change Pivot Table Date Filter

Hope someone can point me in the right direction.

Many thanks.