+ Reply to Thread
Results 1 to 2 of 2

Userform to change Pivot Table filter

  1. #1
    Registered User
    Join Date
    Rhode Island
    MS-Off Ver

    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

  2. #2
    Registered User
    Join Date
    Montreal, Quebec
    MS-Off Ver
    Excel 2007

    Re: Userform to change Pivot Table filter

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1