VBA Using Combo to change Pivot Filter problems if data not in field

[Laial]

I am using the below VBA to change several pivot filters based on a cell called "HOD". This cell is fed from a combo box of set values. The problem I have is that if one of the values from the combo box is selected but it does not appear in the HOD field in my pivot table, what happens is that whatever is selected overwrites the pivot field. I can't work out what I need to add into my code to say, if "HOD" is not in the HOD pivot field, then do nothing, otherwise filter according to what is in "HOD". Hope I have explained that OK

Thanks

Please Login or Register  to view this content.

[marreco]

Hi.

Do you tried to use Error Handler?

See.
http://www.globaliconnect.com/excel/...=79&Itemid=475

[Laial]

Hi, thanks for replying. I am not sure how this would help? If already have in my code "On Error Resume Next" or am I missing something? The issue is that the item selected in the combo box is not in the pivot filter, but when I select that item in the combo it seems to over-ride whatever was in the the pivot filter previously