Share via

Dependents Property [Visio 2003 SDK Documentation]

  • Article

Returns an array of ShapeSheet cells that are dependent on a particular cell of a Microsoft Office Visio shape.

arrayRet = object.Dependents

arrayRet   An array of the cells that are dependent on object.

object    Required. An expression that returns a Cell object.

Version added

2003

Remarks

The Dependents property returns an array of the cells that recalculate their values when the formula or value of object changes.

Example

The following Microsoft Visual Basic for Applications (VBA) macro shows how to use the Dependents property to display a list of cells that are dependent on the Width cell of a rectangle shape.

Public Sub Dependents_Example()

    Dim acellDependentCells() As Visio.Cell
    Dim vsoCell As Visio.Cell
    Dim vsoShape As Visio.Shape
    Dim intCounter As Integer
    
    'Draw a rectangle on the active page.
    Set vsoShape = ActivePage.DrawRectangle(1, 5, 5, 1)
    
    'Get the array of cells dependent on the Width cell of the shape
    acellDependentCells = vsoShape.Cells("Width").Dependents
    
    'List the cell names and their associated formulas
    For intCounter = LBound(acellDependentCells) To UBound(acellDependentCells)

        Set vsoCell = acellDependentCells(intCounter)
        Debug.Print vsoCell.Name & " has this formula: " & vsoCell.Formula

    Next

End Sub

Applies to | Cell object

See Also | Precedents property