Funções VBA exclusivas

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.

Funções de texto

AscW Function [VBA]

Devolve o valor Unicode do primeiro carácter de um expressão de cadeia.

ChrW Function [VBA]

Devolve o carácter Unicode correspondente ao código de carácter especificado.

InStrRev Function [VBA]

Devolve a posição de uma cadeia dentro de outra cadeia, com início no lado direito da mesma.

StrReverse Function [VBA]

Returns the string with the character order reversed.

Funções financeiras

DDB Function [VBA]

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

Função FV [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.

Funções de data e hora

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.

Funções de E/S

Input Function [VBA]

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

Funções matemáticas

Round Function [VBA]

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

Funções de objetos