+ Reply to Thread
Results 1 to 1 of 1

Check boxes linked to Dynamic Pivot Table

  1. #1
    Registered User
    Join Date
    12-28-2007
    Posts
    1

    Check boxes linked to Dynamic Pivot Table

    Hi All,

    I'm quite new to VB for Excel and have a question hopefully you guys can help me with.

    I've created code that will create a pivot table containing 6 RowFields. My idea is to allow the user to dynamically alter the pivot table and either remove or add any one of these RowFields by way of (selecting/unselecting) a check box (one check box for each RowField) taken from the Control Tool Box.

    I've recorded some code and it appears that when adjusting the Pivot Table, the code makes reference to all RowFields as per below, not just the RowField I am removing or adding.

    Please Login or Register  to view this content.
    This presents a problem as I want the user to be able to have any combination of the 6 RowFields.

    I was wondering if anyone can offer some helpful advice.

    Thanks
    Last edited by VBA Noob; 12-28-2007 at 04:03 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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