VBA change PivotTable Filters based on Values in dropdowns

[Melimob]

Hi there, been searching for some code to tweak but none of worked so far.

I have 3 dropdowns on a sheet: Year, Month, Introducer.
Same 3 are filters on a PivotTable5 on same sheet.
When user selects the dropdown values, I want the PivotTable filters to use the same.

I think therefore I need a change on worksheet event but for some reason nothing happens?

All responses gratefully received.

Many thanks

 

[Melimob]

Just to elaborate on this.
I have created a combobox which links the value to a cell.
I have added the code to a change event but still nothing is happening? At the moment I have just written one filter but I need to add two others.
Can anyone advise what is wrong with this code or do I have to put it somewhere else?

Private Sub ComboBox1_Change()
On Error Resume Next
    
    Sheets("INTRODUCER DASHBOARD").PivotTables("PivotTable5").PivotFields("Introducer (Actual)").ClearAllFilters
    Sheets("INTRODUCER DASHBOARD").PivotTables("PivotTable5").PivotFields("Introducer (Actual)").CurrentPage = Sheets("INTRODUCER DASHBOARD").Range("R1").Value
  
End Sub

thanks in advance