Get text value from user property pulldown list

Started by william slaney, June 03, 2022, 08:28:35 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

william slaney

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

Yacine

Write ".ResultStr("")" instead of ".FormulaU"
Yacine