動作物件

本頁為官方文件，一般使用者無法修改，若有任何誤謬，請與官方聯絡。如欲編輯，請至本頁的開放版。

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. Checkboxes can be created using the aforementioned tool or Checkbox Command.

Input Boxes

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.

範例： Input Box with a=a+%0 in 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 Insert Input Box Tool or InputBox Command.

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. Input Boxes can be created using Insert Button Tool or Button Command.

下拉式選單

下拉式選單的功能只有試算表中才有。你可以在儲存格中輸入一個集合（如：A1={1,2,3,4}），然後打開試算表選項，並勾選「使用按鈕與勾選框」，這時儲存格就會變為一個下拉式選單。如果在程式中要使用目前下拉式選單所選擇的項目，可以使用 SelectedIndex 與 SelectedElement 兩個指令。

請看以下的影片說明（沒有錄音）：