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