Show actual Shape Data value in ShapeSheet?

[EnVisMan]

Hi!

I have a problem where I need to see the current cell value for a shape.

In my drawing i have many different shapes with different data. Each shape have the a few labels and a fixed list for each label. The thing is that(in shapesheet) instead of showing the value from the list choice, it is showing the index formula "=INDEX(0,Prop.Row_2.Format)" depending on which index the list choice has.

My problem is that i have some vba code with case statements where i want to do something depending on what data the shape has.

Is there a way to make shapesheet show the actual value instead of the index formula? Or is there a more simple solution?

[Nikolay]

If you want to see value in ShareSheet, right click and select "Display Values" from the context menu (the other option is "Display Formulas")

If you want to get a result (string) value, you should use shape.Cells("YourCell").Result or shape.Cells("YourCell").ResultStr functions instead of shape.Cells("YourCell").Formula