Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables and list boxes
I have 2 pivot tables each w/ a list box (page list box).
What I want to do is make selection on Pivot Table #1 list box an Pivot Table #2 automatically update w/ selection made in Pivot Tabl #1. Any ideas? Validation is not possible on pivot tables -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables and list boxes
Do you mean the normal pivot table Page *DropDown* ?
If so, this does not trigger the Worksheet_Change event, so we have t find another way of running the macro (a button or whatever). Thi example uses a double click in the worksheet and assumes that both Pag cells are range B2. Change this to suit. '-------------------------------------------------------- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range Cancel As Boolean) Worksheets("Sheet1").Range("B2").Value ActiveSheet.Range("B2").Value End Sub '------------------------------------------------------- -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List any duplicates once - no pivot tables | Excel Worksheet Functions | |||
Pivot Tables - Can you just list data and not SUM | Excel Worksheet Functions | |||
Pivot tables off a List | Excel Discussion (Misc queries) | |||
Where has my field list gone for my Pivot Tables? | Excel Worksheet Functions | |||
Pivot Tables - cleaning up combo boxes history | Excel Discussion (Misc queries) |