Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Howdy
I'm currently considering options for my Excel/VBA application I'm working on. I was wondering, is it possible to, rather than showing numeric values for all cells inside a pivot table, to conditionally show form elements inside a pivot table? It is hard to explain why I want to do it, but if possible it could really be a good solution. The numeric values I'd like to replace with form elements would be boolean values, i.e. either 0 or 1, and I'd like to replace them in one case with a checkbox unchecked or checked depending on if it was 0 or 1 respectively, and in another case I'd like to replace the 0 or 1 with a blank image or a "tick" image respectively. Don't get me wrong, I don't want to replace the 'dropdown lists' that are an integral part of Excel's pivot tables with the form elements, but I want to repolace the actual data that is inside the pivot table with the form elements. I hope this is clear! Is this possible or am I getting a bit carried away...? I only recently discovered pivot tables and hence the question. Cheers Thanks a lot for any response Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set Pivot Table Tabular Form to Default | Excel Discussion (Misc queries) | |||
Restricting Data Elements in Pivot Table | Excel Worksheet Functions | |||
PIVOT TABLE FROM A FORM IN ACCESS | Excel Discussion (Misc queries) | |||
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) | |||
Assign macros to dynamically created form elements | Excel Programming |