Optional (in Function Statement) [Runtime]

From LibreOffice Help
Jump to: navigation, search

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.