Insert Function Wizard agrument descriptions.

[Dan Dreger]

I have written several functions in VBA, then saved the sheet as an .xla
which I use as an add-in. The functions appear in the Insert Function
Wizard, as expected - almost. I have not found a way to display the
arguments' descriptive text. I know this is available in in .XLL's through
a call to xlfRegister, but how does one accomplish this through VBA?

 

[Gord Dibben]

Dan

You can add a brief description of your UDF by going to Tools>Macro>Macros.

Type in the name of your UDF and "Options". Add a description and hit OK then
Cancel.

To actually add the arguments you will need something more complex.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

http://longre.free.fr/english/index.html

UNFORTUNATELY................Ballon/Screen Tips are not available with Laurent's
method.


Gord Dibben Excel MVP

I have written several functions in VBA, then saved the sheet as an .xla
which I use as an add-in. The functions appear in the Insert Function
Wizard, as expected - almost. I have not found a way to display the
arguments' descriptive text. I know this is available in in .XLL's through
a call to xlfRegister, but how does one accomplish this through VBA?

Gord Dibben MS Excel MVP