ComboBox Used to Refresh Multiple PivotTables | Excel forum

I have a sheet with 6 pivot tables on, what I'm trying to do is to insert an ActiveX ComboBox where the user will make their selection and it'll then update all of the Pivots. I understand I also need an update button for it to calculate the refresh of the Pivots but I'm struggling with the code which picks up changes to the works. I've set the ComboBox linked cell to C3 to pick up the value entered in the ComboBox;

Private Sub Worksheet_Change()

If Target.Address = Range("C3").Address Then

Me.PivotTables("PivotTable2").PivotFields("MA_Name").CurrentPage = Range("C3").Value
Me.PivotTables("PivotTable3").PivotFields("MA_Name").CurrentPage = Range("C3").Value
Me.PivotTables("PivotTable7").PivotFields("MA_Name").CurrentPage = Range("C3").Value
Me.PivotTables("PivotTable6").PivotFields("MA_Name").CurrentPage = Range("C3").Value
Me.PivotTables("PivotTable12").PivotFields("MA_Name").CurrentPage = Range("C3").Value
Me.PivotTables("PivotTable11").PivotFields("MA_Name").CurrentPage = Range("C3").Value

End If

End Sub

When I make the change in the ComboBox it debugs with Error 424 Object Required and then highlights the code line If Target.Address = Range("C3").Address Then