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")