Page 149 - Microsoft Office Excel 2003 Programming Inside Out

Part 3: The Excel Object Mode
The Application Object

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 Text Accepts a text (string) value.
4 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”.
Chapter 6
64 An array of values Accepts a list of values.

123