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 *** |
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 |