Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

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 omitted.

See also Examples.