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.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Matt Jensen wrote:
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