Insert call values/references inside of a shape

[DashboardNovice]

Let's say I insert a rectangle. And in the rectangle I want to enter a reference to a cell so that the cells value appears in the rectangle, similar to how you can enter a cell reference in a Chart Title box so that the title box is linked to a cell.

So far this isn't working. Is this even possible?

 

[Debraj]

Select the chart Title..
In Formula bar.. use STATIC formula as =B2

 

[DashboardNovice]

Select the chart Title..
In Formula bar.. use STATIC formula as =B2

I want to enter a formula inside of a shape that I inserted such as a rectangle. I was using the Chart title to show a similar example.

 

[Debraj]

use a helper cell..
for example..
if a1 has formula.. =b1 *13
then in c1 use formula as =a1.
and now in shape use formula as =c1.

 

[DashboardNovice]

use a helper cell..
for example..
if a1 has formula.. =b1 *13
then in c1 use formula as =a1.
and now in shape use formula as =c1.

I gave that a try, but I couldn't get it to work. I have a file attached.

 

[Mike H..]

I gave that a try, but I couldn't get it to work. I have a file attached.

Hi,

Click the shape to select it then left click in the formula bar and type = and then select C1 and tap enter. See attached file.

 

[Debraj]

check here..
http://office.microsoft.com/en-001/...tents-in-a-shape-or-text-box-HP005201093.aspx
http://www.officetooltips.com/excel/tips/how_to_insert_cell_content_to_the_shape.html

or follow @Mike H..

 

[DashboardNovice]

Hi,

Click the shape to select it then left click in the formula bar and type = and then select C1 and tap enter. See attached file.

Beautiful. Got it. This will help me so much. Now I won't have to worry about adjusting columns to make things just right. Thank you very much.

 

[DashboardNovice]

check here..
http://office.microsoft.com/en-001/...tents-in-a-shape-or-text-box-HP005201093.aspx
http://www.officetooltips.com/excel/tips/how_to_insert_cell_content_to_the_shape.html

or follow @Mike H..

Thank you very much. I will take a look at these.

 

[Marvin Marquez]

If I want to do it in the opposite way, take the value from the shape to copy it into a cell?

 

[jbarrows]

Hi Marvin, were you able to get it working the 'opposite way'?

 

[NARAYANK991]

Hi ,

Using VBA , the following statement will return the value from a shape :

Activesheet.Shapes(1).TextEffect.Text

The highlighted 1 needs to be changed to suit.

Narayan

 

[jbarrows]

Thanks Narayan.

I should have specified that I was looking for a way to reference it without using VBA, but I don't think that's going to possible. I could create a custom function but I was kind of hoping there was a more native way of referencing the text.

Jason

 

[NARAYANK991]

Hi Jason ,

Sorry , but I don't think there is any way in which a native Excel formula can reference shapes.

Narayan

 

[Badale Ankit]

1. Use a "Helper Cell".
2. Link all your context as normal formula in some cell.
3. Now, link that cell to the one, exactly behind your shape.
4. Now, set the "Shape Fill" to "No Fill"".

PS: Cell in Point 2 and Point 3 can be same.

Check the attachment.