Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Group Pivot Table and Combo Box
I have a pivot table that I would like to create a form or combo box that
will give the end user the option of picking different groups. Such as Days, WTD, MTD, Quarters, YTD. If anyone could get me started I would appreciated. The code I'm using below is what I have but it continues to give me an error. Thanks for the help Private Sub ComboBox1_Change() Sheets("DAILY").PivotTables("Weekly").PivotFields( "DATE").CurrentPage = _ Sheets("DAILY").Range("AI1").Value PivotTables("Weekly").PivotFields("DATE").Group Start:=True, End:=True, Periods:=Array(False, False, False, _ False, True, False, False) PivotTables("Weekly").PivotFields("DATE").Group Start:=True, End:=True, Periods:=Array(False, False, False, _ False, False, True, False) PivotTables("Weekly").PivotFields("DATE").Group Start:=True, End:=True, Periods:=Array(False, False, False, _ False, True, True, False) PivotTables("Weekly").PivotFields("DATE").Group Start:=True, End:=True, Periods:=Array(False, False, False, _ False, False, True, True) End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table group help | Excel Discussion (Misc queries) | |||
Group in Pivot Table | Excel Discussion (Misc queries) | |||
how to group a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table, can't group | Excel Discussion (Misc queries) | |||
Pivot Table - no group on web | Excel Discussion (Misc queries) |