Results 1 to 3 of 3

How to change Pivot table with Combobox selection

Threaded View

Endorphin How to change Pivot table... 12-17-2006, 11:23 AM
MSP77079 Below assumes that you have a... 12-17-2006, 01:02 PM
Endorphin Thank you so much MSP77079,... 12-17-2006, 02:24 PM
  1. #1
    Registered User
    Join Date
    10-27-2006
    Posts
    60

    How to change Pivot table with Combobox selection

    Hi all,

    I am trying to find a way to change a page field on a pivot table with the selection made in a combo box. I am trying to change the "P.5256" to whatever the user selects in the combo box.

    Any Ideas on how to do this?
     
    Sheets("Selected Points Charts").Select
        ActiveSheet.ChartObjects("Chart 1").Activate
        ActiveChart.PivotLayout.PivotTable.PivotFields("Point ID").CurrentPage = _
            "P.5256"
        ActiveChart.SeriesCollection(1).Select
        ActiveChart.SeriesCollection(1).Trendlines.Add(Type:=xlLinear, Forward:=0, _
            Backward:=0, DisplayEquation:=False, DisplayRSquared:=False).Select
        Windows("Points Statistics 2.xls").SmallScroll Down:=21
        ActiveWindow.Visible = False
        Windows("Points Statistics 2.xls").Activate
        ActiveSheet.ChartObjects("Chart 2").Activate
        ActiveChart.PivotLayout.PivotTable.PivotFields("Point ID").CurrentPage = _
            "P.5256"
    Last edited by VBA Noob; 12-17-2006 at 11:30 AM.

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