Action cell (Actions section)

Microsoft Office ShapeSheet

Action cell (Actions section)

See also       Rows

Contains the formula to be executed when a user chooses the command name defined in the corresponding Menu cell.

Remarks

An Action cell is evaluated only when the action occurs, not when the formula is entered.

To reference the Action cell by name from another formula, or from a program using the Cells property, use:

Cell name:

Actions.Action[i]
where i = <1>, 2, 3 …

To reference the Action cell by index from a program, use the CellsSRC property with the following arguments:

Section index:

visSectionAction

Row index:

visRowAction + i
where i = 0, 1, 2…

Cell index:

visActionAction