You are here: All Help Topics > Other Information > Action Events > Set cell value

Set Cell Value Action

The Set Cell Value action enters a specified value in a selected cell.

Under Enter Example

Run Skip Condition

If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed.

 

Cell Number

A cell number

cellno(C945)

Value

The new value of the cell

"4530"

Recalculate

A yes or no decision to recalculate the document after this event is run

"1" (for Yes)

ACTION("SetCellValue", expr1, expr2, expr3)

Where

expr1 = entry under Cell Number

expr2 = entry under Value

expr3 = entry under Recalculate

ACTION("SetCellValue", cellno(C945), "4530","1")

NOTE: The Set Cell Value action treats the Value as a string of text rather than as an integer. To set the value of the selected cell as an integer, use the MKINT function.

Related Topics