EVENTS

Assign a function, that will be executed, if a selected event occurs on the object/shape. Add the EVENTS() function to a shape in the "Events" parameter.

Syntax

=EVENTS([EventHandler1,EventHandler2,...])

Arguments

NameDescription
EventHandler1..NEventhandler defining the event and the action to be executed. Valid handlers are: ONLICK,ONDOUBLECLICK,ONMOUSEDOWN,ONMOUSEUP, ONVALUECHANGE,SHOWDIALOG,SHOWVALUES.

Return Value

TRUE.

Example

FunctionComment
=DRAW.RECTANGLE("ID1", "", "Rect1", 1000, 1000, 3000, 3000,,,, EVENTS(ONCLICK(DELETECELLS(A1:C1)))If the user clicks on the rectangle the cell range A1:C1 will be deleted.