Userform to change Pivot Table filter

Good morning,

I have a predefined Pivot Table report where users use a userform to change the report filter. The textbox on the userform populates a hidden cell in the workbook which then triggers a worksheet change event to update the report filter cell. If the user enters a wrong value, I get a "No item of this name exists in the pivot table report" message which allows you to hit OK to rename the report filter. Can I write code to intercept this message with my own message box that allows the user to hit OK and start again?

Thank you in advance

Hi,
This is what I am trying to do.
Can you tell me how you did it.
What kind of useform element are you using, can select multiple value.

In page value I have CostCenter and has line label I have RessourceName

Both can be multiple selection, How do I pass that to my PivotTable using a VBA macro?

Thanks for all the help yoy can provide
Jean