Microsoft Office Tutorials and References
In Depth Information
Table 6-1. InputBox Type Values
Value
Meaning
Notes
0
A formula
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.
1
A number
Will also calculate a formula, if entered, to return a
number. For example, if =8*8 is entered, the
InputBox will return 64.
2
4
Text
Accepts a text (string) value.
A logical value
Accepts any variant that can be converted to a logical
(True/False)
value.
8
A cell reference, as a
The Set statement must be used to assign the result
Range object
to a Range object.
16
An error value, such as
Returns a string value consisting of the word “Error”
#NULL!
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”.
64
An array of values
Accepts a list of values.
Search JabSto ::




Custom Search