Forum Discussion

hugo francisco jiménez novoa's avatar
hugo francisco jiménez novoa
Copper Contributor
May 30, 2022
Solved

Add help info to UDF

Hi everyone, just a quick question here... It is possible to add help information to a UDF to let the user know how the UDF works and what the possible errors are, and the data is needed for the UDF ...
excel
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    May 30, 2022

    hugo francisco jiménez novoa 

    You can use Application.MacroOptions. Here is a very simple example:

    Function CelsiusToFahrenheit(t As Double) As Double
 CelsiusToFahrenheit = 1.8 * t + 32
End Function

Sub AddDescriptiom()
    Application.MacroOptions Macro:="CelsiusToFahrenheit", _
       Description:="Convert Celsius to Fahrenheit", _
       ArgumentDescriptions:=Array("Temperature in degrees Celsius")
End Sub

    Running the AddDescription macro adds a description of the function as a whole and of its arguments. These will be used if you press fx when creating a formula:

HansVogelaar's avatar
HansVogelaar
MVP
May 30, 2022

hugo francisco jiménez novoa 

You can use Application.MacroOptions. Here is a very simple example:

Function CelsiusToFahrenheit(t As Double) As Double
 CelsiusToFahrenheit = 1.8 * t + 32
End Function

Sub AddDescriptiom()
    Application.MacroOptions Macro:="CelsiusToFahrenheit", _
       Description:="Convert Celsius to Fahrenheit", _
       ArgumentDescriptions:=Array("Temperature in degrees Celsius")
End Sub

Running the AddDescription macro adds a description of the function as a whole and of its arguments. These will be used if you press fx when creating a formula:

  • RobinClay's avatar
    RobinClay
    Brass Contributor
    Aug 03, 2022

    HansVogelaar 

    Looks good !

    But doesn't work for me  😞

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Aug 04, 2022

      RobinClay 

      Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

      • RobinClay's avatar
        RobinClay
        Brass Contributor
        Aug 07, 2022
        Sorry for the delay ! And thank you for your interest.
        I'm afraid this new technology is still byond me ! I can't see how to attach a file, nor how to Paste an image . . .
        However . . I copied your UDFs, and the first works fine.
        But if I click on the fx, and the window comes up, it bears the line
        "Ni help available", and if I click on the bottom left Link "Help on this function", another window pops up with "=the same message.
        And Yes, I corrected the spelling ! changed the final "m" to an "n" in your "Sub AddDescriptiom("

Resources