For interactive worksheets with scripting Action Objects may come handy.
There are four types of them:
Input Boxes work as text inputs for scripts. The script is triggered by changing text in the Input Box and either pressing enter or leaving the Input Box. The inserted value may be accessed using the %0 variable.
a=a+%0in script will increase number a by the entered value. Works only if a is free.
If you want the Input Box 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.
Input Boxes can be created using the Input Box Tool or the InputBox Command.
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.
Buttons can be created using the Button Tool or the Button Command.
If you want to show the contents of a list in a drop-down list
- in the Graphics View: check the Draw as drop-down list box in the Basics tab of the Properties Dialog of the list.
- in the Spreadsheet View: enter a list into the spreadsheet, then check the Use Buttons and Checkboxes box in the Spreadsheet Options.