Forum Discussion

OfficerKD6-37's avatar
OfficerKD6-37
Copper Contributor
Jan 01, 2024
Solved

Custom excel formula, add helper pane visual basic editor to show order of inputs

When making a custom excel formula, how do you add a helper pane in the excel visual basic editor to show which variable to enter when you are using the excel function.

 

See Below:

 

 

I want to be able to see the names of the inputs in the order I enter them.

developer
excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Jan 01, 2024

    OfficerKD6-37 

    You can even create a description for the function and its arguments, by creating and running a macro:

    Sub DescribeMyFunc()
    Application.MacroOptions _
        Macro:="MyFunc", _
        Description:="A custom VBA function", _
        ArgumentDescriptions:=Array("A text string", "A whole number")
End Sub

    The descriptions will be used in the Insert Function wizard:

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 01, 2024

    OfficerKD6-37 

    You can even create a description for the function and its arguments, by creating and running a macro:

    Sub DescribeMyFunc()
    Application.MacroOptions _
        Macro:="MyFunc", _
        Description:="A custom VBA function", _
        ArgumentDescriptions:=Array("A text string", "A whole number")
End Sub

    The descriptions will be used in the Insert Function wizard:

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 01, 2024

    OfficerKD6-37 

    Let's say you create a UDF MyFunc in the Visual Basic Editor:

    Function MyFunc(AName As String, ANumber As Long) As Variant
    ... ' your code goes here
End Function

    In a cell, type =MyFunc

    Press Ctrl+Shift+A.

Resources