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.