Expand Minimize
This topic has not yet been rated - Rate this topic

DEPENDSON Function

Published: July 16, 2012

Creates a cell reference dependency.

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

Parameters

Name

Required/Optional

Data Type

Description

cellref

Required

String

The first cell reference.

cellref2

Optional

String

The second cell reference.

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

OPENTEXTWIN() + DEPENDSON(PinX,PinY)

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.