Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2001
    Location
    Perth,(aka middle of nowhere), Western Australia, Australia
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Argument Descriptions (XL2000 )

    After creating a user defined function I want to add a description for both the function as a whole and for each parameter (as per the built in functions).
    I can add a description for the function as a whole using "properties" in the object browser but can't find a way to add a description for the individual arguments.

    Any ideas?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Argument Descriptions (XL2000 )

    I haven't yet found a way to do that. My workaround it to use clear naming for the arguments:

    Function SumColoredCells(rRangeOfCellsToSum as Range,lColorIndexOfCellsToSum as Long) as double
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Argument Descriptions (XL2000 )

    Ayup, there's no way to do that.

Posting Permissions

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