How to reference a shapesheet cell

[Twixman23]

I have been learning Visio little by little, and now I want to use VBA to reference what is in a particular cell in a ShapeSheet.

I have a Shape (Sheet.XX) and I put a RUNADDON("Database Refresh") in the Actions section of the ShapeSheet.

How do I reference the Actions section in VBA? I am trying to use CellsSRC but I haven't figured out the syntax.

I can reference cells, just not cellsSRC. Any info or pages where I can find the information in great detail is appreciated

Thanks!!
Twixman

 

[johnwm]

Syntax:

objRet = Shape.CellsSRC (section, row, column)

Use the object browser to look up the constants to use for section (under VisSectionIndices), row (under VisRowIndices) and column (under VisCellIndices), as they are not intuitive at all!

Just tested this to get User properties:

With visApp.ActivePage
Debug.Print .Shapes("sheet.7").CellsSRC(visSectionUser, visRowUser, visUserValue)
End With

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[Twixman23]

Thank you very much! I figured it out after playing with it some. I don't know what I was doing wrong. It works though and that is that matters.

Twixman