Microsoft Office Tutorials and References
In Depth Information
Table 6-1. InputBox Type Values
Any valid Excel formula is returned as a text string.
You must use the FormulaLocal property to assign
the formula to a Range object. Cell references are
returned in A1-style and use the ConvertFormula
function to switch to R1C1-style if needed.
Will also calculate a formula, if entered, to return a
number. For example, if =8*8 is entered, the
InputBox will return 64.
Accepts a text (string) value.
A logical value
Accepts any variant that can be converted to a logical
A cell reference, as a
The Set statement must be used to assign the result
to a Range object.
An error value, such as
Returns a string value consisting of the word “Error”
and the error number associated with the error value.
(See Table 6-2 for a list of error values.) Any non-error
value entered returns “Error 2015”.
An array of values
Accepts a list of values.