Inputbox method

VBA allows you to equate a variable to an object, but the variable does not automatically become an object. If you then attempt to use the variable in an expression that requires an object, youll get an "Object required" error message. The Set command lets you define a variable or property as an object. The following example makes the InputBox method return an Object (so that you can use its Address property in addition to its Value property, for example) ... 

The InputBox allows you to pause a macro and request input from the user. There are both an InputBox Function and an InputBox method. 

The differences between the InputBox function and the InputBox method are the following (i) default can be any data type and (ii) the additional argument type num specifies the data type of the return value. The values of type num and the corresponding data types are listed in Table 14-7. Values of type num can be added together. For example, to specify an input dialog box that would accept number or string values as input, use tiie value 1 + 2 = 3 for type num. 

To specify the range of cells to use as data labels, we ll use the InputBox method. We ll define the range as an object variable, so that we can use a For...Each...Next loop. For a code example, see "You Can Define Your Own Objects" in Chapter 14. To convert SeriesCollection(l) into the general case, remember that a specific item in a collection can be referred to by its index number or by its name. We ll use the code... 

See also inputBox Function, MsgBox insert Method... 

See also InputBox Function, MsgBox Insert Method... 

---