Insert Function Wizard agrument descriptions.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan Dreger - 17 Sep 2006 07:19 GMT

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?

Reply to this Message

Gord Dibben - 17 Sep 2006 17:10 GMT

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

Reply to this Message