+ Reply to Thread
Results 1 to 2 of 2

Providing "descriptions" for VBA User Function Arguments

  1. #1
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517

    Providing "descriptions" for VBA User Function Arguments

    I posted this query on the Miscellaneous forum some days ago, and got a description of how to attach a description to a function.
    This was not what I was after. Perhaps someone in this forum can help.

    When I click the fx toolbar button with a standard function,
    for example ROUND(C11,1) I get the Function Arguments dialog box
    with the auguments given as:
    -------------------------------------------------------
    Number C11 = 1405.36
    Num_digits 1 = 1
    = 1405.4
    Rounds a number to a specific number of digits.

    Number is the number you want to round.
    -------------------------------------------------------
    The string "Rounds a number to a specific number of digits." is the function description;
    but how do I get my function to provide the equivalent of the "is the number you want to round." string?
    All I get is (the equivalent of) Number with no followup text.

    This would be clearer if I could upload bit-maps to show what I mean, but unfortunately the web security software here precludes this.
    I hope my description makes sense to someone out there.

    Mark.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482
    http://www.ozgrid.com/VBA/DesciptionToUDF.htm

    I don't think you will be able to make your UDF look like the function wizard,
    I suppose you could do one yourself using a userform, would be cool, but would it be necassary??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1