PDA

View Full Version : Assigning comments to UDF



excelliot
02-14-2007, 04:06 AM
I have created UDF, i wants to assign comments to field. How to assign it.

See picture, i wants to assign comment to PV, FV amd N field.

See code below;
Public Function CV(FV As Double, PV As Double, N As Double) As Double
Application.MacroOptions Macro:="CV", Description:="Cal % of return on Present value(PV) based on Future Value(FV)after N Years", Category:=3
CV = ((FV / PV) ^ (1 / N)) - 1 'FV=Future Values
End Function

Bob Phillips
02-14-2007, 04:31 AM
Laurent Longre provides a DLL to provide it at http://xcell05.free.fr/

Marcster
02-14-2007, 12:32 PM
Here's another link to show you how to do it:

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

Marcster.