Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTables, Page Fields & VBA
I'm working on a report using Pivot Tables. There is a high degree of customisation going on in these reports. What I have done so far is to set up a User Form which makes it easie to alternate between different layouts of the report and to contro what fields are shown in the data area. What I am looking to add to this is a Multi Selection ListBox whic displays all of the currently available page field items i.e PageField = "Region" Items = "Scotland,England,Wales,N Ire" etc. I need the users to 'see' which page fields are currently being used i the report. Really what I want is the same functionality as right clicking on pagefield item and using the list box to create custom page fiel lists, but I want the user to know exactly what they are looking at. For example I only want sales for england and wales, so I hide the res by right clicking and hiding them using the field options panel. The the user selects 'All' to group england and wales together. What I am looking for are some links to websites which example simila problems/solutions or some tips and pointers. Thank ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop page fields here and drop series fields here | Charts and Charting in Excel | |||
How Un-Hide all hidden items in all page fields for PivotTables? | Excel Discussion (Misc queries) | |||
PivotTables - formatting Row fields when grouped | Excel Discussion (Misc queries) | |||
[pivottables] multiple table selection fields update in one click... | Excel Discussion (Misc queries) | |||
How do you get "Show Page" functionality in MSExcel PivotTables | Excel Discussion (Misc queries) |