Exclusive VBA Functions and Statements

LibreOffice Basic adds this set of functions when VBA support is enabled.

These exclusive VBA functions are enabled when the statement Option VBASupport 1 is placed before the first macro of a LibreOffice Basic module.

VBA Statements

Option Compatible Statement

Option Compatible turns on the VBA-compatible Basic compiler mode at the module level. The function CompatibilityMode() controls runtime mode and affects all code executed after setting or resetting the mode.

CompatibilityMode() Function

CompatibilityMode() function is controlling runtime mode and affects all code executed after setting or resetting the mode. Option Compatible turns on VBA compatibility at module level for the LibreOffice Basic compiler.

Option ClassModule Statement

Specifies that the module is a class module that contains members, properties, procedures and functions.

Enum Statement [VBA]

Define enumerations or non UNO constant groups. An enumeration is a value list that facilitates programming and eases code logic review.

Text functions

AscW Function [VBA]

Returns the Unicode value of the first character in a string expression.

ChrW Function [VBA]

Returns the Unicode character that corresponds to the specified character code.

InStrRev Function [VBA]

Returns the position of a string within another string, starting from the right side of the string.

StrReverse Function [VBA]

Returns the string with the character order reversed.

Financial functions

DDB Function [VBA]

Returns the depreciation of an asset for a specified period using the arithmetic-declining method.

FV Function [VBA]

Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).

IPmt Function [VBA]

Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.

IRR Function [VBA]

Calculates the internal rate of return for an investment.

MIRR Function [VBA]

Calculates the modified internal rate of return of a series of investments.

NPer Function [VBA]

Calculates the number of periods for a loan or investment.

NPV Function [VBA]

Calculates the Net Present Value of an investment, based on a supplied discount rate, and a series of deposits and withdrawals.

Pmt Function [VBA]

Calculates the constant periodic payments for a loan or investment.

PPmt Function [VBA]

Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate.

PV Function [VBA]

Returns the Present Value of an investment resulting from a series of regular payments.

Rate Function [VBA]

Returns the interest rate of a loan or an investment.

SLN Function [VBA]

Returns the straight-line depreciation of an asset for one period. The amount of the depreciation is constant during the depreciation period.

SYD Function [VBA]

Returns the arithmetic-declining depreciation rate.

Date and time functions

FormatDateTime Function [VBA]

Applies a date and/or time format to a date expression and returns the result as a string.

MonthName Function [VBA]

The MonthName function returns the localized month name of a specified month number.

WeekdayName Function [VBA]

The WeekdayName function returns the weekday name of a specified day of the week.

I/O Functions

Input Function [VBA]

Returns the open stream of an Input or Binary file (String).

Mathematical Functions

Round Function [VBA]

The Round function returns a number rounded to a specified number of digits.

FormatNumber [VBA]

Returns a string with a number formatting applied to a numeric expression.

Partition Function [VBA]

Returns a string indicating where a number occurs within a calculated series of ranges.

Object Functions

Please support us!