Author Topic: Get text value from user property pulldown list  (Read 292 times)

0 Members and 1 Guest are viewing this topic.

william slaney

  • Newbie
  • *
  • Posts: 8
Get text value from user property pulldown list
« on: June 03, 2022, 03:28:35 AM »
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

  • Hero Member
  • *****
  • Posts: 2952
Re: Get text value from user property pulldown list
« Reply #1 on: June 03, 2022, 04:30:22 AM »
Write ".ResultStr("")" instead of ".FormulaU"
Yacine