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.

--
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

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/
_______

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

Great - thanks guys
Thought I might have been :-)
Cheers
Matt

"Jon Peltier" wrote in message
...
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/
_______

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