Input Integer Dialog Action

Event Function: Input Integer Dialog

The Input Integer dialog creates a dialog box that allows a user to select an integer and have that result written to a cell.

Using the Events tab

Under Enter Example

Run Skip Condition

If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed.

Cell Number

Destination cell for the input

"C6"

Title

Title that appears at the top of the dialog box

"User input"

Prompt

Prompt that appears in the dialog box

"Select number from the range"

Min

Maximum upper limit that can be selected

"50"

Max

Maximum lower limit that can be selected

"500"

Syntax (if entering it in the Equation bar)

ACTION("InputIntegerDialog", expr1, expr2, expr3, expr4, exp5)

Where

expr1 = entry under Cell Number

expr2 = entry under Title

expr3 = entry under Prompt

expr4 = entry under Min

expr5 = entry under Max

How the example will appear in the Equation bar

ACTION("InputIntegerDialog", "C6", "User Input", "Select number from range", "50","500")

Related Topics