Optional (in Function Statement) /text/sbasic/shared/03104100.xhp Sun Microsystems, Inc.
Optional function

Optional (in Function Statement)

Allows you to define parameters that are passed to a function as optional.
See also: IsMissing

Syntax:

Function MyFunction(Text1 As String, Optional Arg2, Optional Arg3)

Examples:

Result = MyFunction("Here", 1, "There") ' all arguments are passed. Result = MyFunction("Test", ,1) ' second argument is missing. See also Examples.