Finance Control

Use the Finance control to create a Finance object to access financial functions.

Syntax

Finance

The Finance control properties, methods, and events listed in the following table are supported:

Properties Methods Events
None DDB None
FV
Ipmt
IRR
MIRR
Nper
NPV
PMT
PPMT
PV
Rate
SLN
SYD

Remarks

    To create a Finance Object

Dim Financial
Set Financial = CreateObject("pVBFinFunc.pVBFinFunc")
Text1.Text = Financial.Pmt(0.0083, 48, 12000)