PC Review


Reply
Thread Tools Rate Thread

Code to change PivotTable selections, based on ActiveX CheckBoxes on a worksheet.

 
 
Victor Dimitrov
Guest
Posts: n/a
 
      25th May 2009


Hi everyone !

I really need your help on this one and would really appreciate any
suggestions you may have for me !

The thing is that I have an Excel Workbook with Raw Data, a big
PivotTable, based on it and finally a few nice looking Graphs.

I have a "Selection" sheet, with ActiveX CheckBoxes for each week of the
year. I want to be able to change the PivotTable selections, based on
the selected CheckBoxes.

For example:
If a user selects 3 CheckBoxes ("w1", "w5" and "w10"), there should be a
macro, assigned to a button, which changes the "Week" selection in
PivotTable1.

I hope you can help me solve this one and thank you in advance for your
time !


Best regards,
Victor


*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
 
 
 
 
Victor Dimitrov
Guest
Posts: n/a
 
      29th May 2009

This is just to inform you that the case has been resolved, using the
Click events of the Check Boxes and calling another procedure to change
the selections in the Pivot Table.


*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Include Dropdowns and Checkboxes in Worksheet Change event Barry Microsoft Excel Programming 1 23rd Nov 2009 05:24 PM
How Do I Change Two Pivot Table Page Selections with VBA Code dmarsh Microsoft Excel Programming 1 28th Jul 2009 03:42 PM
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does ker_01 Microsoft Excel Programming 6 3rd Oct 2008 09:45 PM
Change PivotTable Field By Code Curious Microsoft Excel Programming 0 12th Sep 2007 07:04 PM
creating form with selections that change based on user's previous selection Robert Bogart Microsoft Access Database Table Design 1 15th Jun 2004 06:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:16 PM.