Specifying the Data Type of an Argument

You can specify the data type of an argument passed to a Function procedure by using the As keyword in the Function statement. For example, if the Function procedure MolWt has two arguments, formula (a string) and decimals (an integer), then the statement 

Function MolWt (formula As String, decimals As Integer) 

---

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. 

---