Select

The Select function executes the Graphics Controls function contained in a spreadsheet cell, chosen from a variable list of indexed cell references.

Note: Since the Select function can accept a variable number of references to cells containing dialogs, this function is not configured through a property sheet. This function can be configured directly in the cell or in the formula bar on the Job Edit toolbar. For more information, see Property Sheet.

Select Inputs

Syntax: Select(Title,Index,Auto,Control0,Control1,Control2,...)

Parameter

Description

Title

The name of the Select function as it will appear in the spreadsheet next to the Select control.

Index

Specifies the position number (zero-based) of the Control to execute from the variable list of cell references. The first cell reference is Index 0, the second is Index 1, and so on.

Auto

Specifies whether the Select function can execute automatically (depending on a conditional value in another spreadsheet cell) and manually, or just manually.

0 = manual	The Controls function in the indexed cell will execute only when the Select button is pressed.
1 = manual or programmatic	The Controls function in the indexed cell will execute when the Select button is pressed, or automatically when the Index value changes.

Control0, 1, 2, ...

The variable-length list of references to spreadsheet cells that must contain an OCRMaxAutoTune, Dialog, Wizard, Link, Button, or Select function. For more information, see OCRMaxAutoTune, Dialog, Wizard, Link, Button, or Select.

Select Outputs

Results

A labeled Select control that executes a Graphics Control function from the indexed list of cell references.

For more information, see Controls Functions or Graphics Functions.