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 ...
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 

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