Hi out there,
I have a problem deciphering the selected text value from a user defined shape property cell. The property cell ("DeliverableName") consists of a combo type pulldown list. The text derived output from the code is for example :
"INDEX(2,Prop.DeliverableName.Format)"
Here's the code:
Dim sItemDataProp as string
If oShape.CellExists("Prop.DeliverableName", 1) <> 0 Then
'It exists, get the data
sItemDataProp = oShape.Cells("Prop.DeliverableName").FormulaU
Else
sItemDataProp = "No Data"
End If
What vital method, property or code am I missing to convert INDEX value to text ?
Hope someone can shine a light here, I am stumped.
William
Write ".ResultStr("")" instead of ".FormulaU"