Help for this custom function

Hi, Bonjour, I created custom functions with the help of the add-in files (.xlam), I would like to share my functions with my work colleagues and explain to them how the formulas work via the "...

excel

Formulas and Functions

Macros and VBA

HansVogelaar

Mar 05, 2024

Alan_srgt

You can use Application.MacroOptions for this purpose. For example:

Sub RegistergetRGB1()
    Application.MacroOptions _
        Macro:="getRGB1", _
        Description:="Returns the fill color of a cell", _
        ArgumentDescriptions:=Array("The cell whose fill color you want to return")
End Sub

When you select getRGB1 in the Functions dialog:

And when you click OK:

Forum Discussion

Help for this custom function

Resources