I am trying to link a list box in cell A1 to field1 in a pivottable 1. For example in A1, if i select 1, then I would want field1 in pivottable1 to switch its filter to 1. I know there is a way to do it through VB but my experimental code does not seem to be fuctioning correctly. Any thoughts?

Thank You
PS(I tried uploading a sample file but was not able to attach it)