When one writes a User Defined Function in Excel VBA, this function appears in the function wizard under the category “Custom”. It is possible to set which category the function belongs to by changing the “macro properties” of the UDF.
Unfortunately, VBA does not allow specifying a description for the UDF’s arguments. There is a workaround which uses the old XLM REGISTER function in conjunction with the ExecuteExcel4Macro function from within VBA (as described in the excellent book Professional Excel Development). This function however only accepts 255 characters or less, which is insufficient for UDF’s with more than just one or two arguments and severely limits the amount of text one can use for the explanation of the arguments.
It enables you to set your own category:
and your own descriptions for each argument:
Jan Karel Pieterse
JKP Application Development Services