Pivot table with form elements

  • Thread starter Thread starter Matt Jensen
  • Start date Start date
M

Matt Jensen

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
 
Matt

I'm not a pivot table expert, but I think you're getting a bit carried away.

One option you might consider is formatting those cells with a different
font. You could use Wingdings or some font that has a check mark character
in it. It woudn't be a forms control, but it would at least be a checkmark.
You may have to create some columns in your data to use a formula to convert
the 1's and 0's to whatever character a check mark would be.

BTW, I haven't tried this, just thinking out loud.
 
Hi Matt -

I'm with Dick, I think you might really have been inhaling. My suggestion is
different than his: you could make the pivot table as usual, then use VBA to build
the appearance you want on another sheet, based on what is found at each place in
the table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top