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...
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...