How to display results in a shape?
 

I have a CountIf code and I need to display it's result inside a shape. I
can't figure out how this should be done, does anyone have any tips how this
should be done?
Thanks.

How to display results in a shape?
 

Why not put it in a cell and make the shape transparent?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"T.Lindholm" wrote in message
...
I have a CountIf code and I need to display it's result inside a shape. I
can't figure out how this should be done, does anyone have any tips how
this
should be done?
Thanks.

How to display results in a shape?
 

Hi,

If the value is in a cell you can link the shapes displayed text to that
cell.

Select the shape and then via the formula bar enter the cells reference,
i.e.:

=Sheet1!$A$1

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"T.Lindholm" wrote in message
...
I have a CountIf code and I need to display it's result inside a shape. I
can't figure out how this should be done, does anyone have any tips how
this
should be done?
Thanks.

How to display results in a shape?
 

Thanks for the tips Andy, and Bob too, this helps me alot.

"Andy Pope" wrote:

Hi,

If the value is in a cell you can link the shapes displayed text to that
cell.

Select the shape and then via the formula bar enter the cells reference,
i.e.:

=Sheet1!$A$1

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"T.Lindholm" wrote in message
...
I have a CountIf code and I need to display it's result inside a shape. I
can't figure out how this should be done, does anyone have any tips how
this
should be done?
Thanks.