|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
Passing Arguments by Position and by Name
When you call a Sub or Function procedure, you can pass arguments by position — in the order in which they appear in the procedure's definition — or you can pass them by name, without regard to position.
When you pass an argument by name, you specify the argument's declared name followed by a colon and an equal sign (:=), followed by the argument value. You can supply named arguments in any order.
For example, the following Sub procedure takes three arguments:
When you call this procedure, you can supply the arguments by position, by name, or by using a mixture of both.
You can call the procedure studentInfo with its arguments passed by position and delimited by commas, as shown in the following example:
If you omit an optional argument in a positional argument list, you must hold its place with a comma. The following example calls studentInfo without the age argument:
You can supply arguments both by position and by name in a single procedure call, as shown in the following example:
In the preceding example, no extra comma is necessary to hold the place of the omitted age argument, since birth is passed by name.
When you supply arguments by a mixture of position and name, the positional arguments must all come first. Once you supply an argument by name, the remaining arguments must all be by name.
Passing arguments by name is especially useful when you call a procedure that has more than one optional argument. If you supply arguments by name, you do not have to use consecutive commas to denote missing positional arguments. Passing arguments by name also makes it easier to keep track of which arguments you are passing and which ones you are omitting.
You cannot pass arguments by name to avoid entering required arguments. You can omit only the optional arguments.
You cannot pass a parameter array by name. This is because when you call the procedure, you supply an indefinite number of comma-separated arguments for the parameter array, and the compiler cannot associate more than one argument with a single name.