Naming Macro Function Parameters

[Scooterman23]

I'm trying to create a macro in Excel that takes in a list of parameters, and I'm having trouble remembering the order to enter the parameters.

Functions defined in excel show the parameter such as = PV(rate, nper, pmt, [fv], [type])

How can I create my Macro to output the name of parameters needed such as pvStudy("initial","operating","revenue","salvage","life","marr","study")


Macro attached:

Function pvStudy(initial As Double, operating As Double, revenue As Double, salvage As Double, life As Double, marr As Double, study As Double) As Double


Dim Rebuy As Double
Dim times As Double
Dim repurchase As Double
Dim AnnualPresent As Double
Dim FinalSalvage As Double


times = Round((study / life), 0)


AnnualPresent = -PV(marr * 0.01, study, (revenue + operating))

For i = 1 To times
tempvar = -PV(marr * 0.01, life * i, (initial + salvage))
repurchase = repurchase + tempvar
Next i

FinalSalvage = -PV(marr * 0.01, study, salvage)

pvStudy = (initial + FinalSalvage + repurchase + AnnualPresent)

End Function

 

[Jon Peltier]

Sounds like you need to use MacroOptions. This tutorial doesn't look too bad:

VBA MacroOptions to Add UDF Description

 

[Fluff]

Also if you enter =pvStudy( and then click the fx button by the side of the formula bar it will show the names of the arguments.