Share via

DEPENDSON Function

  • Article

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.