UDF parameter description

Hi

Is there a way that I can describe the paraeters of my function so the user
will the description when he clicks on the "black equals" button to the left
of the formula bar?

Thanks

Rob

There is a way to describe the function itself, and you could use that to describe the parameters.

In VBE, open the Object Browser (F2).
In the top dropdown box, select VBAProject (or whatever you have named your project)
In the left-hand list select the module where your UDF is. It should be in the list on the right now.
Right-click on it, and select properties. Type whatever you want in the Description box.

Hope that helps.

Hi Rob,

This is not natively supported in Excel but you may like to look at Laurent
Longre's Funcustomize add-in which is freely downloadable at:

http://xcell05.free.fr/


---
Regards,
Norman



"Rob" <Rob@discussions.microsoft.com> wrote in message
news:14B9D806-84AE-48ED-BA05-BE0233AEEF74@microsoft.com...
> Hi
>
> Is there a way that I can describe the paraeters of my function so the
> user
> will the description when he clicks on the "black equals" button to the
> left
> of the formula bar?
>
> Thanks
>
> Rob

Rob shared this with us in microsoft.public.excel.programming:

> Hi
>
> Is there a way that I can describe the paraeters of my function so
> the user will the description when he clicks on the "black equals"
> button to the left of the formula bar?

Not with default Excel, but Google for "FunCustomize" by Laurent
Longre. It's a combination of a dll and an add-in (xla), iirc.

--
Amedee Van Gasse using XanaNews 1.17.4.1
If it has an "X" in the name, it must be Linux?