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 |
To create a Finance ObjectDim Financial
Set Financial = CreateObject("pVBFinFunc.pVBFinFunc")
Text1.Text = Financial.Pmt(0.0083, 48, 12000)