Pivot Tables

D

dok112

I have a userform, and it has 2 textboxes, is there a way that I can
write a macro that will only display that data on a pivot table between
the 2 dates entered in these textboxes?

Right now I have the below, but I don't want to have to have all the
dates written like this.

With thisworkbook.sheets("CARS Survey Results by
Date").PivotTables("PivotTable2").PivotFields("Date")
..PivotItems("9/28/2005").Visible = True
..PivotItems("9/29/2005").Visible = True
..PivotItems("9/30/2005").Visible = True
End With

I would like to enter "9/28/2005" in textbox1 & "9/30/2005" in textbox
2 and have it display only these results.

Any help will be greatly appreciated.
 
D

dok112

I think this will be better suited for the programming board...so I will
post it there instead. ~Thanks~
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top