DEPENDSON Function

Creates a cell reference dependency.

Syntax

DEPENDSON(cellref [, cellref2,...])

Parameters

Name Required/Optional Data Type Description
cellref
Required
String
The first cell reference.
cellref2
Optional
String
The second cell reference.

Remarks

This function always returns FALSE. It has no effect when used in an Event row or an Action cell.

Example

OPENTEXTWIN() + DEPENDSON(PinX,PinY)

Opens the text block for a shape whenever the shape's PinX or PinY cells change.