How to display results in a shape?

[Guest]

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.

 

[Bob Phillips]

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)

 

[Andy Pope]

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

 

[Guest]

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