im tying to change the data in the filter of a pivot table based on what value is entered.

so far i have:
Please Login or Register  to view this content.
i have only been doing VBA for about 3 weeks

the first inputbox changes a Cell B5 no problem but i can't change the PivotItems to the variable.

thanks in advance, if you need more info or a demo of the speadsheed then just ask.