+ Reply to Thread
Results 1 to 3 of 3

Change info of 3 Pivot Tables with a Userform (dummy workbook inside)

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Chile
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Change info of 3 Pivot Tables with a Userform (dummy workbook inside)

    ĦHello people of Excelforum! I really need your help if someone knows how to do what I need to...

    On the dummy archive I uploaded I have 3 PivotTables in 3 different sheets and a command button to open Userform1 that contains 15 checkbox.

    What I need to accomplish is after selecting the checkboxes and clicking the "Ok" command button of the archive, the 3 PivotTables get arranged simultaneously with the values selected on the UserForm1.

    Main Goal Select in the PivotTables the Months and Years selected on the Userform1

    The Dummy Archive has all the codes erased because i couldn't find the solution.

    I Just need this thing to finish my job

    I've tried some attempts but failed completely. The one posted below fails as it doesn't recognize the variable "PT" as the PivotTable.

    Please Login or Register  to view this content.
    Any input would be apreciated. I think it's easy to do it, but i'm just learning to code on VBA
    Cool forums you have here. Been surfing it for the last days and helped me a lot :P
    Attached Files Attached Files
    Last edited by HendrixSpirit; 01-10-2014 at 08:55 AM.

  2. #2
    Registered User
    Join Date
    01-09-2014
    Location
    Chile
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Change info of 3 Pivot Tables with a Userform (dummy workbook inside)

    żDoes someone at least understand what I'm asking? My English is not the best i think ....

    I edited the thread to do the info more concise and clear.

    Bump No response

  3. #3
    Registered User
    Join Date
    01-09-2014
    Location
    Chile
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Change info of 3 Pivot Tables with a Userform (dummy workbook inside)

    Bump No response

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding new items to Multi-Column Listbox on seperate Userform
    By Hutinni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2013, 02:43 PM
  2. Replies: 0
    Last Post: 04-16-2012, 07:43 PM
  3. Pivot Tables for Multi-Column Range
    By duGly in forum Excel General
    Replies: 2
    Last Post: 09-13-2010, 02:43 PM
  4. Multi pivot tables using one page filter
    By cbh35711 in forum Excel General
    Replies: 1
    Last Post: 06-10-2008, 02:44 AM
  5. multi sheet pivot tables
    By bamf in forum Excel General
    Replies: 1
    Last Post: 06-01-2005, 06:05 PM

Tags for this Thread

Bookmarks

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