Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Insert the values directly as the function arguments

Sub pmt()     MsgBox WorksheetFunction.pmt(0.0825 / 12, 360, -150000) End Sub