Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub ComboBox1_Change()
- Dim sheet As Worksheet
- Dim pt As PivotTable
- Dim ptField As PivotField
- Set sheet = ThisWorkbook.Worksheets("Overview")
- Set pt = sheet.PivotTables("Main")
- Set ptField = pt.PivotFields("CustomersId")
- ptField.ClearAllFilters
- ptField.CurrentPage = Me.ComboBox1.Value
- End Sub
Add Comment
Please, Sign In to add comment