Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Intellisense for User Defined Functions

Currently User Defined Functions (UDFs) in Excel will not show intellisense to tell the user what arguments need to be supplied. This makes them very difficult to use.

There's a discussion here:
http://stackoverflow.com/questions/16903587/the-quest-for-the-excel-custom-function-tooltip

Whether the future of UDFs is in VBA or something else, the ability to define intellisense is vital.

236 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Nick shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

Thanks for the suggestion Nick. We’ve got some related work we’re looking at soon, and we’ll be sure to carefully consider if we can get a fix in for this then. As always, more votes helps – so keep voting for the things you care about most.

Thanks,
John [MS XL]

11 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Wayne Erfling commented  ·   ·  Flag as inappropriate

    I have begun to use Application.MacroOptions to help with this a bit. Example follows:

    Sub DescribeFunctions()
    '======================

    Dim FunctionName As String
    Dim FunctionDesc As String
    Dim Category As String
    Dim ArgDesc(1 To 7) As String

    FunctionName = "YesOrNo"
    FunctionDesc = "Transforms various common values to " & _
    "specified ""yes"" or ""no"" values"
    Category = 7 'Text category
    ArgDesc(1) = "Input value or reference"
    ArgDesc(2) = "Return value for unrecognized InputValue " & _
    "(special value ""xlErrValue"" [case-sensitive])"
    ArgDesc(3) = "Accept ""T"" or ""F"" (single character)"
    ArgDesc(4) = "Accept ""0"" or ""1"" (single character)"
    ArgDesc(5) = "Accept ""true"" or ""false"" [case-insensitive]"
    ArgDesc(6) = "Value for ""yes"""
    ArgDesc(7) = "Value for ""no"""""

    Application.MacroOptions _
    Macro:=FunctionName, _
    Description:=FunctionDesc, _
    Category:=Category, _
    ArgumentDescriptions:=ArgDesc
    End Sub

  • Wayne Erfling commented  ·   ·  Flag as inappropriate

    named arguments for function calls with OPTIONAL arguments in the underlying VBA (or c#? or VB?) would be nice, too.

  • Marcus commented  ·   ·  Flag as inappropriate

    UDFs are so helpful to me and I would like to get Intellisense completion for this as well.
    Please enable this in the future patches of Excel

  • Hassan commented  ·   ·  Flag as inappropriate

    Built in functions show the tooltip with the variable names. Having this for custom VBA functions beyond just the name would make it significantly easier to program in functions.

  • Govert commented  ·   ·  Flag as inappropriate

    @Gareth - The UDFs in Analysis32.xll do not have IntelliSense. In recent Excel versions (I think Excel 2010) those functions have been incorporated into Excel as built-in functions, and no longer require Analysis32.xll to run.

    No .xll or other add-in can provide IntelliSense support without the add-in Excel-DNA IntelliSense helper library (https://github.com/Excel-DNA/IntelliSense).

  • Gareth Hayter commented  ·   ·  Flag as inappropriate

    Also, seeing as the UDFs in Analysis32.xll have Intellisense, it is obviously possible with the current versions of Excel, so PLEASE tell us how to accomplish it!

Feedback and Knowledge Base