Visual Basic for Applications Reference
Call Statement
Transfers control to a Sub procedure, Function procedure, or dynamic-link library (DLL)procedure.
Syntax
[Call] name [argumentlist]
The Call statement syntax has these parts:
| Part | Description |
| Call | Optional; keyword. If specified, you must enclose argumentlist in parentheses. For example: |
Call MyProc(0) |
|
| name | Required. Name of the procedure to call. |
| argumentlist | Optional. Comma-delimited list of variables, arrays, or expressions to pass to the procedure. Components of argumentlist may include the keywords ByVal or ByRef to describe how the arguments are treated by the called procedure. However, ByVal and ByRef can be used with Call only when calling a DLL procedure. |
Remarks
You are not required to use the Call keyword when calling a procedure. However, if you use the Call keyword to call a procedure that requires arguments, argumentlist must be enclosed in parentheses. If you omit the Call keyword, you also must omit the parentheses around argumentlist. If you use either Call syntax to call any intrinsic or user-defined function, the function's return value is discarded.
To pass a whole array to a procedure, use the array name followed by empty parentheses.