PDA

View Full Version : Pivot tables - VBA



Emperor
05-16-2011, 06:00 AM
Hi All,

I'm working on a Pivot Table and need to control it with VBA.
I have Excel 2003 (at work)

I have created a Userform in which employees can make a selection to filter data. There are 3 items I need help on;

1. How can I use entered dates to (start + end date) to select a range in the pivot table?

2. Somewhat the same problem is what i'm having with a m2 range. Employees can select 5 different ranges which should lead to a selection change in the Pivot Table.

3. I've got several listboxes in my Userform, how can I translate this to selections in my Pivot Table?

Any help is appriciated!

Mathijs

p.s. I know in 2007 date ranges are (more) simple, but my company 200+ computers will not change there version anytime soon...