Custom function description

[Manish Kumawat]

Dear All,

Please provide some tips on UDF as i need to put the description in the custom function. i have made a formula for computing the SIP (systematic investment plan). I need to add a brief description of the formula like when a user enters the formula the description will be available just like the built-in excel formulas.

Function sip(amount As Double, rate As Double, tenure As Double) As Double
sip = Application.WorksheetFunction.FV(((FV(rate, 1 / 12, 0, -100, 1) - 100) / 100), tenure, -amount, 0, 1)
End Function

Thanks in advance
Manish Kumawat

 

[Hui]

On the worksheet type =SIP( now press Ctrl+Shift+A

 

[NARAYANK991]

Hi ,

See this link for lots of additional information :

https://stackoverflow.com/questions/4262421/how-to-put-a-tooltip-on-a-user-defined-function

Narayan