Displays a dialogue box containing a message and sets a name to the text entered into its input field.
Syntax:
INPUT(message:text, name:text, button1:text {, button2:text})
A dialogue box is displayed containing the text message and containing an input field.
button1 and the optional button2 supply the text which appears on button(s) within the dialogue box.
Sets name to the text typed into the input field and returns 1
when button1 is clicked or 2
when button2 is clicked.
Only makes sense in custom functions.
Example:
INPUT("Work out the average of", "range", "OK", "Cancel")
displays a dialogue box containing the message Work out the average of and hands the name of the range typed in back to the custom function, along with the value 1
if button1 is clicked and 2
if button2 is clicked.