Context help on custom formulas

fddekker

Board Regular
Joined
Jun 30, 2008
Messages
63
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>
 
Last edited:

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Threads
1,118,404
Messages
5,571,918
Members
412,426
Latest member
DeficientOptimism
Top