I think this might be better suited to be posted here instead of the
charting forum.

--------------------------------------------------------------------------------

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("Dat e")
..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.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=478854