Use the Finance control to create a Finance object to access financial functions.
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 |
Dim Financial
Set Financial = CreateObject("pVBFinFunc.pVBFinFunc")
Text1.Text = Financial.Pmt(0.0083, 48, 12000)