Setting pivot table field (current page) to a chosen value

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

Hello,

I have the following code:

ActiveSheet.PivotTables("PvtVarianceRpt2").PivotFields
("Line").CurrentPage = cboLine.Name

Where cboLine is a combo drop down list.

It keeps asking for "Object required"

How might I go around fixing this?

Thanks in advance for the replies,
Grant.
 
For a combobox from the Control toolbox:

Dim str As String
str = ActiveSheet.OLEObjects("cboLine").Object.Value

ActiveSheet.PivotTables("PvtVarianceRpt2") _
.PivotFields("Line").CurrentPage = str
 
You must log in or register to reply here.

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

Using macro to switch 'page' in a pivot table? 1
Pivot Tables in VBA: Problem with AddFields Method 2
Changing the CurrentPage items in a Pivot Table 1
Update Pivot Table Filters based on a Cell Value in Excel 2007 0
Automatically Update a Pivot Table Field Used as Column / Row 1
Change a pivot field based on another pivot field 10
Pivot table refresh problem 2
Change Page Field in a Pivot Table and Print Chart + Data 2

Back
Top