Excel Pivot Table - setting page field value

[Sanjay Shah]

Hi,
I have written a vba code in which i set the page field value to a value given by the user.

However if the value given by the user does not match any of the item, i want the pivot table to show no values.

is this possible ?

sanjay shah