Action Objects

For interactive worksheets with scripting Action Objects may come handy. There are four types of them

Checkboxes

Checkboxes are graphical representations of Boolean values. See Check Box to Show / Hide Objects Tool for details.

Text fields

Textfields work as text inputs for scripts. The script is triggered by changing text in the textfield and either pressing enter or leaving the textfield. The inserted value may be accessed using the %0 variable.

Example: Textfield with a=a+%0 in script will increase number a by the entered value.

If you want the textfield to change value of a free object (or redefine dependent object), you may define that object as linked. This way you don't have to insert any script.

Buttons

Buttons are meant to trigger scripts by being clicked. Although scripts can be triggered by clicking any other object (e.g. an image, using buttons for this makes your worksheet more intuitive.

Comboboxes

Comboboxes are available only in Spreadsheet View. You may enter a list into spreadsheet cell and then turn on option Use Buttons and Checkboxes in Spreadsheet Tab of Options Dialog. The list will turn into a combobox; the selected element may be obtained using SelectedIndex Command and SelectedElement Command.