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
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