Context help on custom formulas

[fddekker]

I have four custom formulas that I use a lot. Countcellcolor, Countfontcolor, Sumcellcolor and Sumfontcolor. Co-workers would also like to use it, but they always ask me what the input format is. I would like to add details to the functions so that they can use it independently.</SPAN>
Is there a way that :</SPAN>

1. I can add the context help that comes up like when you type =COUNTA or</SPAN>
2. I can invoke a “Functions arguments” input form for the parameters like the way formulas from the FORMULAS tab do it?

Alternatively, how can I add these functions to an add-in ribbon? I assume is the create a macro that just call the function and perhaps place the input form in the macro?

Thanks in advance.

Francois
</SPAN>

 

[njimack]

If you're using 2010 or 2013, take a look at Spreadsheet Page Excel Tips: User-Defined Function Argument Descriptions In Excel 2010

 

[fddekker]

Neil, thanks .... thats great!