Consulting

Results 1 to 3 of 3

Thread: Assigning comments to UDF

  1. #1

    Assigning comments to UDF

    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;
    [VBA]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[/VBA]
    A mighty flame followeth a tiny sparkle!!



  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Laurent Longre provides a DLL to provide it at http://xcell05.free.fr/

  3. #3
    VBAX Mentor Marcster's Avatar
    Joined
    Jun 2005
    Posts
    434
    Location
    Here's another link to show you how to do it:

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

    Marcster.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •