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

V

Victor Dimitrov

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

Victor Dimitrov

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Using VB to change a defined formula within a pivottable 0
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Print a selection based on checked checkboxes 0
Referencing checkboxes on a worksheet from a form 8
Filtering data based on multiple checkbox selections 0
How to copy ActiveX Controls which are locked on a sheet 1
Protect sheet with PivotTable based on OLAP data 0

Top