VBA Parameters
Describes available VBA parameter types and the valid values.
Most VBA functions require you to supply values for one or more parameters. Table 2-1 lists the parameter types and the valid values for each type:
Table 2-1 VBA Parameters
Parameter | Value |
---|---|
Text | A word or phrase or name in quotation marks. For example:
|
Boolean |
|
Range object | A cell, row or column, one or more selections of cells, or a three-dimensional range address, surrounded by quotation marks. For example:
|
Number | A number without quotation marks and without commas. For example:
|
List of strings | A list of text values separated by commas. For example: "Qtr1", "Actual", "Oregon" |
Constant | A predefined constant from smartview.bas
|
Default value |
Note: Many parameters have default values or behavior that the function uses if you specify Null or Empty. If you do not specify a value for such parameters, use Null or Empty. See the description of each function for default values of such parameters. |
Note:
Oracle Smart View for Office and VBA require Excel events to be enabled in order to function properly. Turning off Application.EnableEvents may result in incorrect behavior.