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.

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" <(E-Mail Removed)> wrote in message
news:74357C82-B377-49CB-BD9B-(E-Mail Removed)...
>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.

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" <(E-Mail Removed)> wrote in message
news:74357C82-B377-49CB-BD9B-(E-Mail Removed)...
>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.

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" <(E-Mail Removed)> wrote in message
> news:74357C82-B377-49CB-BD9B-(E-Mail Removed)...
> >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.
>