| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to display the same shape on every worksheet? | Excel Discussion (Misc queries) | |||
| display results 2 of 2 | Excel Discussion (Misc queries) | |||
| Make a cell display the contents of a shape | Excel Worksheet Functions | |||
| Display next to last results | Excel Worksheet Functions | |||
| Display and Hide a text or Auto Shape box | Excel Programming | |||
![T.Lindholm[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
