Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2007
Visio 2007
Visio 2007 Software Development Kit
Visio 2007 ShapeSheet Reference
ShapeSheet Reference
Functions
ABS Function
ACOS Function
AND Function
ANG360 Function
ANGLETOLOC Function
ANGLETOPAR Function
ARG Function
ASIN Function
ATAN Function
ATAN2 Function
BITAND Function
BITNOT Function
BITOR Function
BITXOR Function
BKGPAGENAME Function
BLEND Function
BLOB Function
BLUE Function
BOUND Function
CALLTHIS Function
CATEGORY Function
CEILING Function
CELLISTHEMED Function
CHAR Function
COMPANY Function
COS Function
COSH Function
CREATOR Function
CY Function
DATA1 Function
DATA2 Function
DATA3 Function
DATE Function
DATETIME Function
DATEVALUE Function
DAY Function
DAYOFYEAR Function
DECIMALSEP Function
DEFAULTEVENT Function
DEG Function
DEPENDSON Function
DESCRIPTION Function
DIRECTORY Function
DOCCREATION Function
DOCLASTPRINT Function
DOCLASTSAVE Function
DOCMD Function
DOOLEVERB Function
EVALCELL Function
EVALTEXT Function
FIELDPICTURE Function
FILENAME Function
FIND Function
FLOOR Function
FORMAT Function
FORMATEX Function
FORMULAEXISTS Function
GETREF Function
GETVAL Function
GOTOPAGE Function
GRAVITY Function
GREEN Function
GUARD Function
HELP Function
HOUR Function
HSL Function
HUE Function
HYPERLINK Function
HYPERLINKBASE Function
ID Function
IF Function
INDEX Function
INT Function
INTERSECTX Function
INTERSECTY Function
INTUP Function
ISERR Function
ISERRNA Function
ISERROR Function
ISERRVALUE Function
KEYWORDS Function
LEFT Function
LEN Function
LISTSEP Function
LN Function
LOC Function
LOCALFORMULAEXISTS Function
LOCTOLOC Function
LOCTOPAR Function
LOG10 Function
LOOKUP Function
LOTUSNOTES Function
LOWER Function
LUM Function
LUMDIFF Function
MAGNITUDE Function
MANAGER Function
MASTERNAME Function
MAX Function
MID Function
MIN Function
MINUTE Function
MODULUS Function
MONTH Function
NA Function
NAME Function
NOT Function
NOW Function
NURBS Function
OPENFILE Function
OPENGROUPWIN Function
OPENPAGE Function
OPENSHEETWIN Function
OPENTEXTWIN Function
OR Function
PAGECOUNT Function
PAGENAME Function
PAGENUMBER Function
PAR Function
PI Function
PLAYSOUND Function
PNT Function
PNTX Function
PNTY Function
POLYLINE Function
POW Function
QUEUEMARKEREVENT Function
RAD Function
RAND Function
RECTSECT Function
RED Function
REF Function
REPLACE Function
REPT Function
REWIDEN Function
RGB Function
RIGHT Function
ROUND Function
RUNADDON Function
RUNADDONWARGS Function
RUNMACRO Function
SAT Function
SATDIFF Function
SECOND Function
SETATREF Function
SETATREFEVAL Function
SETATREFEXPR Function
SETF Function
SHADE Function
SHAPETEXT Function
SIGN Function
SIN Function
SINH Function
SQRT Function
STRSAME Function
STRSAMEEX Function
SUBJECT Function
SUBSTITUTE Function
SUM Function
TAN Function
TANH Function
TEXTHEIGHT Function
TEXTWIDTH Function
THEME Function
THEMEGUARD Function
THEMERESTORE Function
TIME Function
TIMEVALUE Function
TINT Function
TITLE Function
TONE Function
TRIM Function
TRUNC Function
TYPE Function
TYPEDESC Function
UNICHAR Function
UPPER Function
USE Function
USERUI Function
WEEKDAY Function
YEAR Function
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

DEPENDSON Function

Office 2007

Creates a cell reference dependency.

Syntax

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

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.



Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.