# Exclusive VBA functions

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.

## InStrRev Function [VBA]

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

## 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 Present Value of an investment resulting from a series of regular payments.

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

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

## Input Function [VBA]

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

## Round Function [VBA]

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

• Me

• RTL