access the formula of a cell in the ShapeSheet (instead of the val

[mikeFin]

When I want to work with the formula of a cell in VBA, I use:

vsShape.Cells("Prop.msvCalloutField").Formula

How can I do that in the shape sheet?



Example
--------

In the cell "Prop.msvCalloutField"
the formula is: "Sheet.1082!Prop.MyHouse_A"
and the value: 55

In the user.myCell1 I want to have the last character of the string of the
formula.
If I do
right(Prop.msvCalloutField,1)
I get 5 instead of A