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 Input Box Tool or 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. Input Boxes can be created using Button Tool or 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 window of the list.
- in the Spreadsheet View: enter a list into the spreadsheet, then check the Use Buttons and Checkboxes box in the Layout tab of Options Dialog.