+ Reply to Thread
Results 1 to 2 of 2

Pivot Tables

  1. #1
    Forum Contributor
    Join Date
    06-13-2004
    Posts
    120

    Pivot Tables

    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.

  2. #2
    Forum Contributor
    Join Date
    06-13-2004
    Posts
    120
    I think this will be better suited for the programming board...so I will post it there instead. ~Thanks~

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1