Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to change PivotTable selections, based on ActiveX CheckBoxes on a worksheet.
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to change PivotTable selections, based on ActiveX CheckBoxes on a worksheet.
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display all pivottable filter selections | Excel Worksheet Functions | |||
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
Change PivotTable Field By Code | Excel Programming | |||
Remove old selections in Pivottable row field dropdown list | Excel Programming | |||
Repost: cut/paste excel cells w/ ActiveX checkboxes to Word | Excel Programming |